SQL Server Quick Tips
Earlier this year I made a series of videos that were played before the start of several DBA Fundamentals presentations. These videos gave viewers something SQL related to watch while the...
2019-09-17
2 reads
Bert Wagner
Whitespace, Letter Case, and Other Things That Prevent Plan Reuse
Watch this week’s episode on YouTube. Last week’s post briefly mentioned that SQL server may not reuse a query plan from cache if there is a small difference in whitespace....
2019-09-16 (first published: 2019-09-03)
528 reads
How I Troubleshoot SQL Server Execution Plans
Watch this week’s video on YouTube. Today I’m concluding my series on SQL Server execution plans by sharing the specific steps I take when troubleshooting a slow performing query....
2019-09-12 (first published: 2019-08-27)
1,823 reads
Tracking Who Last Changed a Row
This post is a response to this month's T-SQL Tuesday #118 prompt by Kevin Chant. T-SQL Tuesday is a way for the SQL Server community to share ideas about different database and professional...
2019-09-10
11 reads
Tracking Who Last Changed a Row
This post is a response to this month's T-SQL Tuesday #118 prompt by Kevin Chant. T-SQL Tuesday is a way for the SQL Server community to share ideas about different database and professional...
2019-09-10
6 reads
Whitespace, Letter Case, and Other Things That Prevent Plan Reuse
Watch this week's video on YouTube
Last week's post briefly mentioned that SQL server may not reuse a query plan from cache if there is a small difference in whitespace.
In addition...
2019-09-03
18 reads
Whitespace, Letter Case, and Other Things That Prevent Plan Reuse
Watch this week's video on YouTube
Last week's post briefly mentioned that SQL server may not reuse a query plan from cache if there is a small difference in whitespace.
In addition...
2019-09-03
4 reads
How I Troubleshoot SQL Server Execution Plans
Watch this week's video on YouTube
Part 1: Introduction to Execution Plans
Part 2: Overview of Statistics
Part 3: Reading an Execution Plan
Part 4: Commonly Troublesome Operators
Part 5: Troubleshooting Execution Plans
Today I'm...
2019-08-27
18 reads
How I Troubleshoot SQL Server Execution Plans
Watch this week's video on YouTube
Part 1: Introduction to Execution Plans
Part 2: Overview of Statistics
Part 3: Reading an Execution Plan
Part 4: Commonly Troublesome Operators
Part 5: Troubleshooting Execution Plans
Today I'm...
2019-08-27
4 reads
SQL Server Execution Plan Operators
Watch this week’s Execution Plan Operators episode on YouTube. SQL Server Execution Plan Operators When examining a query’s execution plan, certain operators tend to crop up over and over...
2019-08-26 (first published: 2019-08-13)
1,576 reads
Blogs
AI: Blog a Day – Day 6: Embeddings – How AI Understands
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
The Book of Redgate: Mistakes
By Steve Jones
This is kind of a funny page to look at. The next page has...
ADF Pipeline Debugging Fails with BadRequest – The Sequel
A while ago I blogged about a use case where a pipeline fails during...
Forums
Dynamic Unpivot
I have a table I didn't design that has tons of repeating groups in...
Writing as an Art and a Job
Comments posted to this topic are about the item Writing as an Art and...
String Similarity II
Comments posted to this topic are about the item String Similarity II
Question of the Day
String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers