Don’t Get Slimed By Bad Parameter Sniffing
Listen! Do you smell something? Are you suffering from random, unexplained slowdowns? Users complaining about queries that sometimes run fast,...
2013-12-09
1,235 reads
Listen! Do you smell something? Are you suffering from random, unexplained slowdowns? Users complaining about queries that sometimes run fast,...
2013-12-09
1,235 reads
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2013-12-06
357 reads
It started like any other Monday following a long holiday weekend. Hundreds of emails to filter through, a new client...
2013-12-03
503 reads
Wow, can you believe it’s been a month already since I posted the first issue of “What’s In My Utility...
2013-11-30
1,096 reads
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2013-11-29
990 reads
If you’ve followed along to this point, and have assembled the pieces as I’ve given them to you, you’re now...
2013-11-26 (first published: 2013-11-19)
3,845 reads
Well, do you know? You’re the DBA, the guy in charge, the guy who gets pounced on first thing in...
2013-11-25
892 reads
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2013-11-22
466 reads
…stays in Vegas, except when it comes to chocolate. After walking more than 1500 miles over the past 9 months,...
2013-11-21
501 reads
Everybody still with me? Have you tried the script from Part 5? Did you notice how SLOW the Active Directory...
2013-11-20
766 reads
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Hi everyone I asked this earlier but the desired outcome is a bit different...
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Comments posted to this topic are about the item Multiple Deployment Processes
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers