Different Engines I seem to have gotten quite a few questions about this lately, so I’m going to write down…
Facts Yesterday we looked at how unused indexes can muck up the buffer pool, because writes to them will bring…
Gritty You may occasionally see in your favorite monitoring tool, or Most Fantastic And Glorious Script For Determining Whom Activity…
Fall Guy Let’s say we have a super important query. It’s not really important. None of this is important.
|
1 2 3 4 5 |
SELECT u.DisplayName, u.Reputation, u.CreationDate FROM dbo.Users AS u WHERE u.CreationDate >= DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE()), 0) AND u.Reputation < 6 ORDER BY u.CreationDate DESC; |
…
Two Words Alright, I’ve lied to you already. There are way more than two words involved, here. I recently had…
Erroneous While a lot of people speak highly of optimistic locking because it cuts down on blocking issues, I think…
Let’s Say We Have A Bad Query I know you don’t have bad queries. You’re smart people. But some people do!…
Stay Sober I recently came across a bad locking problem. It was one of those things that happened “suddenly” and…
But I Need To Roll That Back It all sounds like a great idea. You want your stored procedure to…
Taking A Hint There are all sorts of fun hints you can staple onto your queries that will make them…