This Is Not A Solution
Right off the bat, I want you to know that this is not a solution, and I’ll get to why in a minute. I’m writing this mainly because every once in a while I’ll try …
Tag: Performance
I’m Not Ready To Go To Conferences Without My Friends
Icky Yucky
Conferences have always been gross. Always.
This was true before COVID, too. You’d be hard-pressed to not find “nerd flu” trending around them, and they were gross for a lot of the same reasons that are being …
Forced Parameterization Extended Events That Don’t Work
Would I Could I
There are a couple Extended Events that I’ve tried to get working at various times:
- forced_param_clause_skipped_reason: Fired for every clause that was skipped during forced parameterization.
- forced_param_statement_ignored_reason: Fired when forced parameterization was not applied for the
A SARGability Riddle
Use The Force
I had a RABID FAN ask me an interesting question about a query. I can’t use theirs, but I can repro the question.
The question was: if using ISNULL in a where clause isn’t SARGable, how …
Darling Data Is An ECIF Enabled Supplier!
Other People’s Money
Microsoft loves getting people into their Azure services. They love it so much that they’re willing to pay for partners to help customers get them up there in the cloudy stuffs.
I mean, unless they’re making Azure …
When Spills Cause tempdb Contention
Temptables
I was helping a client troubleshoot a scalability issue recently, where during one point in their workload tempdb went out of control.
What was puzzling them was that nothing in the stored procedure did anything with temporary objects, cursors, …
SQL Server Features I Still Need To Talk People Into
Booze Schmooze
As a counterpart to yesterday’s post, I have a list of Great Ideas™ that sometimes it’s hard to get people on board with, for some reason.
Don’t get me wrong, some people can’t jump on this stuff fast …
SQL Server Features I Still Need To Talk People Out Of
We Rust
Consulting gives you a lot of opportunities to talk to a lot of people and deal with interesting issues.
Recently it occurred to me that a lot of people seem to confer magic button status to a lot …
You Probably Don’t Need To Offload Reads
Moneybags
Duplicating data for reporting, outside of moving it to a data warehouse where there’s some transformations involved, can be an expensive and perilous task.
Your options come down to a native solution like AGs, Replication, or Log Shipping. You …
An Annoying OPTIMIZE FOR Limitation
Infrequent
I have occasionally cheated a little and used OPTIMIZE FOR some_value to fix a parameter sniffing issue that didn’t have any other viable options available to it.
This is a pretty rare situation, but there’s a place for everything. …