Previously We had a couple queries we wanted to make fast, but SQL Server’s missing index request had mixed results.…
Once Upon A Time I asked you to design one index to make two queries fast. If we look at…
Just One Index I want both of these queries to be fast.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 |
SELECT TOP (5000) p.LastActivityDate, p.PostTypeId, p.Score, p.ViewCount FROM dbo.Posts AS p WHERE p.PostTypeId = 4 AND p.LastActivityDate >= '20120101' ORDER BY p.Score DESC; SELECT TOP (5000) p.LastActivityDate, p.PostTypeId, p.Score, p.ViewCount FROM dbo.Posts AS p WHERE p.PostTypeId = 1 AND p.LastActivityDate >= '20110101' ORDER BY p.Score DESC; |
Get to work.
Dangarang
Seriously.
Darnit While helping a client out with a performance problem recently, I ran into something kind of funny when creating…
Concerns If you compare the things that non-SARGable queries cause issues with alongside the things that bad implicit conversions cause…
The Memes On The Blogs Fall Mainly On The Aughs Unless your column is unique, and defined as unique, and…
Thanks Though I’m excited about this feature. I’m not being negative, here. I just want you, dear reader, to have…
That, There Intermediate result materialization is one of the most successful tuning methods that I regularly use. Separating complexity is…