HELLO GUAM! If you’re planning on attending SQL Saturday Washington, DC, why not play hooky from work and spend the…
Sniff If you’re starting from scratch with column store, here are some links that’ll help you get a better understanding…
Special Relativity To get you started exploring the Stack Overflow column store database, here are some queries that show how…
Gett Itt If you want to download the database, here’s the magnet link for the torrent. I don’t have another…
Stack Over Sharing Rather than an F5 script to do this, I decided to make a stored procedure out of…
In The Way Back Machine I really wanted a version of the Stack Overflow data dump that was all clustered…
Rarities I ran into a very funny situation while working with a client recently. They were using Entity Framework, and…
Sounds Great Startup Expression Predicates can be helpful. They may also exacerbate parameter sniffing issues in similar ways to IF…
Checklist This is always fun to talk to people about, because of all the misconceptions around the concept. You need…
What This Isn’t I’m not writing about how if you use NOT IN, and suffer from NULL values in a…