[Video] Fundamentals of Stored Procedures at SQLBits
Anybody can write a stored procedure with a little help from Google. This session is about how to […]
t-sql
Generate Random Dates in T-SQL
The post Generate Random Dates in T-SQL appeared first on SQLServerCentral.
T-SQL Comment Best Practices for SQL Server
The post T-SQL Comment Best Practices for SQL Server appeared first on SQLServerCentral.
Different ways to Convert a SQL INT Value into a ...
The post Different ways to Convert a SQL INT Value into a String Value appeared first on SQLServerCentral.
Working with T-SQL function AVG ()
This article will explain SQL Server average function, AVG(), and its use cases. Many times, we need to […]
Randomizing the Day Inside a Month Using T-SQL
I recently ran across an interesting situation in our development databases. We have begun to protect various PII […]
Getting results using less T-SQL
The post Getting results using less T-SQL appeared first on SQLServerCentral.
The 6-Year-Old T-SQL Book That Never Goes Out of Style
You’ve been working with Microsoft SQL Server for yeeears, and you’re pretty confident that you know how to […]
Don’t Treat SQL Like a Programming or Scripting Language.
In a programming language like C# or Java, you tell the computer what to do, in order. Get […]
The basic T-SQL SELECT statement
The post The basic T-SQL SELECT statement appeared first on SQLServerCentral.
Use Cases for WHILE and GOTO Loops with T-SQL for ...
The post Use Cases for WHILE and GOTO Loops with T-SQL for Time Series Data appeared first on […]
SQL Server Monitoring Using Free Tools
Do you sometimes wonder how the pieces of your SQL Server systems are doing over time? Do you […]
Playing popular game of Wordle using T-SQL
A current frenzy surrounding the game of Wordle has swept the community. I have been playing this game […]
Error Handling Quiz Week: Where Are You Handling Errors?
This week’s series on error handling has been an eye opener for many of us. We’ve laughed. We’ve […]
Quantifier predicates
The post Quantifier predicates appeared first on SQLServerCentral.
Performance Tuning Using Free Tools, Part 2
Does the cost of running SQL Server often surprise you? The cost may come from buying on-premises hardware […]
Error Handling Quiz Week: Making a Turkey Sandwich with XACT_ABORT
CAN YOU BELIEVE THAT HOT MESS IN YESTERDAY’S POST?!? I know, right? You thought that by combining try/catch […]
Error Handling Quiz Week: Combining Transactions And TRY/CATCH
In yesterday’s epic cliffhanger, you might have been shocked to discover that a plain ol’ transaction does not […]
Error Handling Quiz Week: Tryin’ TRY/CATCH
Let’s say we have two tables, Parent and Child, and we need to guarantee that they both get […]
How to Create a FOR Loop in SQL Server
The post How to Create a FOR Loop in SQL Server appeared first on SQLServerCentral.
BETWEEN the two of us
The post BETWEEN the two of us appeared first on SQLServerCentral.
How LAG compares to other techniques
The post How LAG compares to other techniques appeared first on SQLServerCentral.
Executing a TSQL batch multiple times using GO
The post Executing a TSQL batch multiple times using GO appeared first on SQLServerCentral.
Most T-SQL Queries Don’t Even Try to Handle Errors.
David Tovee asked a great question in yesterday’s Mastering Query Tuning class. He asked his fellow students, “How […]
Using Coalesce to Clean Up Reports
The T-SQL language is quite extensive and includes many functions that are useful for various purposes. One of […]
GoTo Looping
Looping over a set of records is a very common operation conducted in applications, integrations, data warehouse, reporting, […]
Migrate Key-Value Pairs from Python Dictionary to SQL Server via ...
The post Migrate Key-Value Pairs from Python Dictionary to SQL Server via JSON appeared first on SQLServerCentral.
Mergers and acquisitions in Insurance
The post Mergers and acquisitions in Insurance appeared first on SQLServerCentral.
Opening JSON Data with T-SQL
The post Opening JSON Data with T-SQL appeared first on SQLServerCentral.
What does SET NOCOUNT ON do?
When you’re working with T-SQL, you’ll often see SET NOCOUNT ON at the beginning of stored procedures and […]
SQL Server Resource Governor Game
The post SQL Server Resource Governor Game appeared first on SQLServerCentral.
9 Signs Your T-SQL Might Fail a Code Review
It’s hard to set absolute rules about, “Feature X should absolutely never be used.” However, there are some […]
SQL Server T-SQL CASE Statement Examples
The post SQL Server T-SQL CASE Statement Examples appeared first on SQLServerCentral.
Navigating Trees With CTE
Introduction This article shows how common table expressions (CTE) in SQL Server are naturally suited for navigating trees, […]
Never, Ever, Ever Start T-SQL Comments with Two Dashes
There are two ways you can write comments in T-SQL: –By starting a line with two dashes, or […]
Scripts to Automate Creating and Loading a SQL Server Table
The post Scripts to Automate Creating and Loading a SQL Server Table appeared first on SQLServerCentral.
T-SQL Tips and Tricks
The post T-SQL Tips and Tricks appeared first on SQLServerCentral.
#TSQL2sday 136 Invitation: Blog About Your Favorite Data Type (Or ...
T-SQL Tuesday is a monthly blogothon where we get together and write about a different topic. I’m hosting […]
sqldf in R Example for SQL Server
The post sqldf in R Example for SQL Server appeared first on SQLServerCentral.
Getting started with the SQL MERGE statement
This article is focused on beginners who have already started writing SQL queries and are now diving deep […]
Multiple Regression Model Enhanced with Bagging
The post Multiple Regression Model Enhanced with Bagging appeared first on SQLServerCentral.
Spoofing Data Convincingly: Text Data
The most difficult data to fake or generate is convincing text. To mimic any commercial business process for […]
How to Batch Updates A Few Thousand Rows at a ...
You’ve got a staging table with millions of rows, and you want to join that over to a […]
How to Insert Rows and Get Their Identity Values with ...
Say you’ve got a two-step process where you’re: Inserting rows into a table that has an identity column, […]
Check Windows Services Status with T-SQL
The post Check Windows Services Status with T-SQL appeared first on SQLServerCentral.
Managing Cross-Database Object References
The post Managing Cross-Database Object References appeared first on SQLServerCentral.
How Scalar User-Defined Functions Slow Down Queries
When your query has a scalar user-defined function in it, SQL Server may not parallelize it and may […]
Why Full Text’s CONTAINS Queries Are So Slow
SQL Server’s full text search is amazing. Well, it amazes me at least – it has so many […]
Handling the Duplication of Records
Problem While working with one of my Risk Advisory clients, I came upon an issue of duplicate records […]
NoSqlOnSql
Introduction NoSqlOnSql is a strict syntactical superset of SQL; it adds NoSQL document-oriented capabilities to the SQL language. […]