Plan Cache Liars – Erik Darling Data

How OPTIMIZE FOR UNKNOWN Makes Troubleshooting Problems Harder

Posted on October 8, 2021September 29, 2021 by Erik Darling

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 Execution Plan Is Lying To You: Cached Temp Tables

Posted on March 6, 2020February 15, 2020 by Erik Darling

Ain’t No Stress On Me

…

Signs Your Execution Plan Is Lying To You: Startup Expressions

Posted on February 18, 2020February 18, 2020 by Erik Darling

You’ll Go Blind

…

Signs Your Execution Plan Is Lying To You: Batch Costs

Posted on February 17, 2020January 2, 2020 by Erik Darling

Batchered

…

Signs Your Execution Plan Is Lying To You: Operator Costs

Posted on February 14, 2020January 2, 2020 by Erik Darling

Pennywise

…

Signs Your Execution Plan Is Lying To You: Spills and Memory Grants

Posted on February 13, 2020January 2, 2020 by Erik Darling

Milky

…

Signs Your Execution Plan Is Lying To You: Nested Loops

Posted on February 12, 2020January 2, 2020 by Erik Darling

Hellish

…

Signs Your Execution Plan Is Lying To You: Merge Joins

Posted on February 11, 2020January 2, 2020 by Erik Darling

Mergin’ Around

…

Signs Your Execution Plan Is Lying To You: Sub Executions

Posted on February 10, 2020January 2, 2020 by Erik Darling

What It Did?

…

Signs Your Execution Plan Is Lying To You: Repartition Streams

Posted on February 7, 2020January 2, 2020 by Erik Darling

Steakenly

…