Put Out I see people using OUTPUT to audit modifications from time to time, often because “triggers are bad” or…
Yes We Have No Bananas I speak with a lot of people who have SQL Server performance problems. Sometimes they’re…
Options Ahoy There are lots of great options out there for figuring out what’s happening on a server. If you’re…
Wet Wednesday, Thirsty Thursday Everyone loves a deal, and if you’re attending SQL Saturday Chicago, here’s a great one on…
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…
Well, huh