In my Twitch & YouTube live streams, some questions seem to come up every week. I’m not expecting this post to stop ’em by any means – most folks on the live stream don’t seem to read the blog regularly – but I thought I’d share ’em here.
Q: Why is the same query sometimes fast and sometimes slow, depending on where I run it?
It’s most likely parameter sniffing.
Q: My index maintenance jobs take forever. What should I do?
When you rebuild a 50GB table’s indexes, you’re basically reloading that table from scratch. SQL Server has to make