Cardinality: Not Just For The Birds
Watch this week's video on YouTube
When building indexes for your queries, the order of your index key columns matters. SQL Server can make the most effective use of an...
2019-01-29
5 reads
Bert Wagner
Optimizing for Ad Hoc Workloads
Watch this week’s episode on YouTube.
The execution plan cache is a great feature: after SQL Server goes through the effort...
2019-02-07 (first published: 2019-01-22)
2,182 reads
Optimizing for Ad Hoc Workloads
Watch this week's video on YouTube
The execution plan cache is a great feature: after SQL Server goes through the effort of generating a query plan, SQL Servers saves that...
2019-01-22
6 reads
Optimizing for Ad Hoc Workloads
Watch this week's video on YouTube
The execution plan cache is a great feature: after SQL Server goes through the effort of generating a query plan, SQL Servers saves that...
2019-01-22
7 reads
SQL FAILS with Andy Mallon, Erin Stellato, and Mr. Anonymous!
Watch this week’s video on YouTube.
While most of us strive to make as few mistakes as possible when it comes...
2019-01-25 (first published: 2019-01-15)
2,198 reads
SQL FAILS with Andy Mallon, Erin Stellato, and Mr. Anonymous!
Watch this week's video on YouTube
While most of us strive to make as few mistakes as possible when it comes to our servers and data, accidents do occasionally happen.
Sometimes...
2019-01-15
2 reads
SQL FAILS with Andy Mallon, Erin Stellato, and Mr. Anonymous!
Watch this week's video on YouTube
While most of us strive to make as few mistakes as possible when it comes to our servers and data, accidents do occasionally happen.
Sometimes...
2019-01-15
3 reads
T-SQL Documentation Generator
This post is a response to this month’s T-SQL Tuesday #110 prompt by Garry Bargsley. T-SQL Tuesday is a way...
2019-01-08
257 reads
T-SQL Documentation Generator
This post is a response to this month's T-SQL Tuesday #110 prompt by Garry Bargsley. T-SQL Tuesday is a way for the SQL Server community to share ideas about...
2019-01-08
14 reads
T-SQL Documentation Generator
This post is a response to this month's T-SQL Tuesday #110 prompt by Garry Bargsley. T-SQL Tuesday is a way for the SQL Server community to share ideas about...
2019-01-08
3 reads
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
Why the following cmds in sequence do not work
I need to delete rows from both the temporal main and history tables. The...
When SQL Server Central Went Down
Comments posted to this topic are about the item When SQL Server Central Went...
The String Distance I
Comments posted to this topic are about the item The String Distance I
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers