Spools Of A Feather There are plenty of spools in query plans, and they’re all pretty well labeled. Index Table…
Q&A4U Every Friday at Noon EST, I answer your SQL Server questions live on YouTube. I understand, not everyone can…
Optimizer Optimizes Sometimes, the optimizer can take a query with a complex where clause, and turn it into two queries.…
This Is Not An Exit Interview Talking to lots of different types of people about SQL Server gives you a…
No, No It Doesn’t But it’s fun to prove this stuff out. Let’s take this index, and these queries.
1 2 3 4 5 6 7 8 9 |
CREATE INDEX ix_fraud ON dbo.Votes ( CreationDate ); SELECT * FROM dbo.Votes AS v WHERE v.CreationDate >= '20101230'; SELECT * FROM dbo.Votes AS v WHERE v.CreationDate >= '20101231'; |
…
So Where In Boston Are You From? Weymouth? I’ll be presenting for NESQLÂ at the User Group on the 9th, and…
ICYMI Last week’s thrilling, stunning, flawless episode of whatever-you-wanna-call-it. ICYDWMINT I’ll be doing these LIVE every Friday at Noon EST,…
Cruel, Cruel Number One is the loneliest number. Sometimes it’s also the hardest number of rows to get, depending on…
In A Row? When you’re reading query plans, you can be faced with an overwhelming amount of information, and some…
On Twitter (More unfortunate words were never spoken) I decided to offer a free three hour block of time to…