SQL Server 2026: BAGI Edition (#TSQL2SDAY 100!)
Category:
tsql-programming
It’s T-SQL Tuesday’s 8 year birthday (or close enough), and Adam Machanic has challenged us with the question: what will the world be like when T-SQLTuesday turns 16?
kendra little
EstimateRowsWithoutRowGoal helps you see: is it a statistics problem?
Category:
query-performance
, sql-server
SQL Server Management Studio version 17.5 adds a welcome feature for execution plans: a new visual attribute named EstimateRowsWithoutRowGoal.
Forced Plan Confusion: Is_Forced vs Use Plan = True
Category:
query-performance
, sql-server
Identifying that a query plan has been bossed around in Query Store can be a bit tricky, because it can appear in different ways.
Can I Force Multiple Plans for a Query in Query Store?
Category:
query-performance
Nope.
At least, not right now.
New SQLChallenge: Defuse the Deadlock
Category:
monitoring-troubleshooting
, sql-server
When I first created SQLWorkbooks, I distilled what it was all about down into one sentence: “Learn SQL Server by Solving Problems.”
This month, I introduce my first SQLChallenge, which distills that down into practice. The SQLChallenge features 23 minutes of video with scripts that you can use to reproduce and solve the problem yourself.
Formatting a VTT Caption File into a Transcript with Sublime Text and Multiple Regular Expressions
Category:
career
Do you ever need to use a text editor to apply regular expressions to files? If so, this post is for you! If not, you may wanna skip it and just return to it if you ever need it.
Does a Clustered Index Give a Default Ordering?
Category:
query-performance
, sql-server
I recently got a great question: if I order by a column where all rows in that column have the same value, will SQL Server then order the results by the clustered index key?