At Least For Now
SQL Server 2022 has a new feature in it to help with parameter sensitive query plans.
That is great. Parameter sensitivity, sometimes just called parameter sniffing, can be a real bear to track down, reproduce, and …
Tag: DBA
SQL Server 2022: What The Heck Is sp_copy_data_in_batches?
Make It Or Not
I’m gonna be honest with you, dear reader, because without honesty we’ve got nothing.
Except lies — which you know — those can be comforting sometimes. Hm. I’ll have to think about that one for a …
SQL Server 2022: GENERATE_SERIES Causes Parallel Deadlocks In A Transaction
Many Times!
These table valued functions of the built-in variety have this problem.
This one is no exception. Well, it does throw an exception. But you know.
That’s not exceptional.
DROP TABLE IF EXISTS
dbo.select_into;
BEGIN TRAN
SELECT
id =
… SQL Server 2022 GENERATE_SERIES: Some Notes At Release Time
Yep, I know
It’s the first public CTP. Things will change. Things will get better. Think about the rich history of Microsoft fixing stuff immediately, like with adding an ordinal position to STRING_SPLIT.
That came out in SQL Server …
Desperately Seeking SQL: Advice For Small Companies Trying To Hire Quality Developers
On Sight
I’m gonna take a quick break from (mostly) technical content to blog about a problem I see day in and day out when working with clients: Bad SQL©.
The stuff I normally blog about — why some things …
Finding Query Store Queries With Missing Index Requests In SQL Server 2019
All The Pretty Little Caveats
I’ve said quite a bit about missing index request utility generally in SQL Server, even as recently as last week!
But then I got a user question about using Query Store to do something …
Comparing Query CPU And Logical Reads Using The Plan Cache In SQL Server
Let’s Not Kid Ourselves
There are lots of things that can go wrong with SQL Server, performance-wise. Just about anything can fly off the handle.
Recently, I was handing out a passing thought on Twitter that caught the attention of …
How SQL Server 2019 Helps You Find Queries That Have Missing Index Requests
bigtime
In the quest for me trying to get people to upgrade to a not-old-and-busted version of SQL Server, this is one that I talk about a lot because it really helps folks who don’t have all the time in …
What Do Missing Index Requests Really Mean In SQL Server?
Scripts Ahoy
There are a million scripts out there that will give you all of the missing index requests for a database (or even a whole server).
Some will even try to prioritize based on the metrics logged along with …
Proving That SQL Server T-SQL Scalar UDFs Execute Once Per Row
Scripted Content
If you use this script, you can follow along with the results.
The sys.dm_exec_function_stats DMV is only available in SQL Server 2016+, so if you’re on an earlier version than that, you should focus your energies on upgrading.…