Break free from the limitations of history retention and take control at the job or even step level.
A subtle redirection
See what improvements were made in SentryOne Plan Explorer 19.0.2.
Aaron Bertrand shares his slide deck from a recent presentation at the Charlotte SQL Server User Group, "Fix Slow Queries. Fast."
In part 2 of this series, we add another way to further isolate multiple threads of a bulk import process.
In the first of a 2-part series, see how you can easily reduce contention between multiple bulk import threads.
If you use scalar user-defined functions, and can't take advantage of new handling in SQL Server 2019, see some other ways to reduce the impact on performance.
What a great experience to host T-SQL Tuesday #99. I could not have predicted that so many of you would be willing to share personal details about your life outside of SQL Server, and reading them all kind of blew me away. I thought this would be an interesting way […]
I'm hosting this month's T-SQL Tuesday, and I gave you a choice: tell us something you're passionate about outside of the tech realm, or talk about your favorite (or least favorite) T-SQL bad habit / best practice. I hope that most people choose the former, but I will be happy […]