Execution Plans – Erik Darling Data

An Unfortunate Side Effect Of OUTPUT

January 20, 2020 Erik Darling Leave a comment

Put Out I see people using OUTPUT to audit modifications from time to time, often because “triggers are bad” or…

Continue Reading →

Unclogging SQL Server

January 14, 2020 Erik Darling 3 Comments

Oft Evil I had a client recently with, wait for it, a performance problem. Or rather, two problems. The OLTP…

Continue Reading →

Let’s Design An Index Together Part 3

January 13, 2020 Erik Darling 5 Comments

Previously We had a couple queries we wanted to make fast, but SQL Server’s missing index request had mixed results.…

Continue Reading →

Let’s Design An Index Together Part 2

January 10, 2020 Erik Darling Leave a comment

Once Upon A Time I asked you to design one index to make two queries fast. If we look at…

Continue Reading →

Let’s Design An Index Together Part 1

January 9, 2020 Erik Darling 24 Comments

Just One Index I want both of these queries to be fast.

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;