Bad Names
When we talk about finding queries to tune, there’s an unfortunate term that gets thrown around: Expensive Queries.
Why is it unfortunate? Well, it reinforces the wrong mindset when it comes to query tuning, and leads people down …
Category: Plan Cache Liars
How OPTIMIZE FOR UNKNOWN Makes Troubleshooting SQL Server Performance Problems Harder
Detained
Despite the many metric tons of blog posts warning people about this stuff, I still see many local variables and optimize for unknown hints. As a solution to parameter sniffing, it’s probably the best choice 1/1000th of the time. …
Signs Your SQL Server Execution Plan Is Lying To You: Cached Temp Tables
Ain’t No Stress On Me
Going Further
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount on to my blog readers if you click from here. …
Signs Your SQL Server Execution Plan Is Lying To You: Startup Expressions
You’ll Go Blind
Going Further
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount on to my blog readers if you click from here. I’m also …
Signs Your SQL Server Execution Plan Is Lying To You: Batch Costs
Batchered
Going Further
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount on to my blog readers if you click from here. I’m also available for …
Signs Your SQL Server Execution Plan Is Lying To You: Operator Costs
Pennywise
Going Further
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount on to my blog readers if you click from here. I’m also available for …
Signs Your SQL Server Execution Plan Is Lying To You: Spills and Memory Grants
Milky
Going Further
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount on to my blog readers if you click from here. I’m also available for …
Signs Your SQL Server Execution Plan Is Lying To You: Nested Loops
Hellish
Going Further
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount on to my blog readers if you click from here. I’m also available for …
Signs Your SQL Server Execution Plan Is Lying To You: Merge Joins
Mergin’ Around
Going Further
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount on to my blog readers if you click from here. I’m also available …
Signs Your SQK Server Execution Plan Is Lying To You: Sub Executions
What It Did?
Going Further
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount on to my blog readers if you click from here. I’m also …