Unavoidable Having some key lookups in your query plans is generally unavoidable. You’ll wanna select more columns than you wanna…
Facts Yesterday we looked at how unused indexes can muck up the buffer pool, because writes to them will bring…
Lost In The Woods When you find unused indexes, whether using Some Script From The Internet™, sp_BlitzIndex, or Database Telepathy,…
To Taste Indexes remind me of salt. And no, not because they’re fun to put on slugs. More because it’s…
Grey Matter Often when query tuning, I’ll try a change that I think makes sense, only to have it backfire.…
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…
What You Make Of It We’ve got this query. Handsome devil of a query. You can pretend it’s in a…
Funtime I’ve added a couple ideas to User Voice. The ideas are pretty simple: Eager Index Spools Should Generate Missing…
Fall Guy Let’s say we have a super important query. It’s not really important. None of this is important.
|
1 2 3 4 5 |
SELECT u.DisplayName, u.Reputation, u.CreationDate FROM dbo.Users AS u WHERE u.CreationDate >= DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE()), 0) AND u.Reputation < 6 ORDER BY u.CreationDate DESC; |
…