Oft Evil I had a client recently with, wait for it, a performance problem. Or rather, two problems. The OLTP…
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.
Honk Honk People often trash cursors even when they’re used for perfectly fine reasons. I understand that this reaction may…
I AIN’T NO Wher
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…