Unavoidable Having some key lookups in your query plans is generally unavoidable. You’ll wanna select more columns than you wanna…
Lost In The Woods When you find unused indexes, whether using Some Script From The Internet™, sp_BlitzIndex, or Database Telepathy,…
Happy Little Operators This month’s T-SQL Tuesday is a fun one. There’s only one problem: I’ve already blogged about my…
Rabbit, Rabbit I know, you’re sitting there and you’re staring at this post thinking “but I use Plan Explorer”. I…
Grey Matter Often when query tuning, I’ll try a change that I think makes sense, only to have it backfire.…
Outline In SQL Server 2019, a few cool performance features under the intelligent query processing umbrella depend on cardinality estimation.…
Will Travel If you recall yesterday’s post, we added a couple two column indexes to the Posts table. Each one…
This Comes Up A Lot When I’m working with clients, people who don’t spend a lot of time working with…
Down With Big Query
Many Have Entered, Few Have Left For some background on Exchange Spills, check out this Great Post™ by Joe. The…