Author: Erik Darling

Restoring tempdb since GETDATE(). Now blogging at ErikDarlingData.com.

CTEs, Inline Views, and What They Do

April 7, 2015

By now, you have probably heard of CTEs And you may have even heard them referred to as Inline Views. Really, an Inline View can be any type of derived table. It's very easy to illustrate when one may turn into a performance problem with CTEs, if you aren't careful. A lot of people think…

Performance Tuning

Online Index Creation and Cruel Defaults

March 31, 2015

Have you ever been watching queries crawl, feeling sort of helpless because you can't change them? And even if you could, it's hitting a new custom column in an ISV table that no one bothered to tell you about. I've been there. I've been pomade deep there.

I've also had my Robot tell me: "there's an index for that, Erik."