Category: Indexing

Greentexting

The problem with relying on any data point is that when it’s not there, it can look like there’s nothing to see.

Missing indexes requests are one of those data points. Even though there are many reasons why they …

Puzzle Pieces

I was investigating a query slowdown recently, and came across something kind of odd with windowing functions and order by.

Let’s talk about these three queries:

SELECT u.DisplayName,
       ROW_NUMBER() OVER (ORDER BY u.UpVotes) AS UpVotesWhatever, --UpVotes first
       ROW_NUMBER() 

Couldn’t We All

Let me ask you a question: If I told you that all the numbers in an integer column were either:

• > 0
• >= 1

You’d probably agree that the lower number you could possible see is 1.…