Manage SQL Server Agent History More Effectively
March 26, 2019 | 0
Break free from the limitations of history retention and take control at the job or even step level.
A subtle redirection
Break free from the limitations of history retention and take control at the job or even step level.
See what improvements were made in SentryOne Plan Explorer 19.0.2.
Get a quick overview of one of the most important features in SQL Server 2019.
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.
This tip shows a neat trick with CROSS APPLY that lets older versions of SQL Server ignore columns in your metadata queries that don't exist yet.
Read a quick overview Scalar UDF Inlining, a long-awaited feature in SQL Server 2019 that will improve the performance of some workloads.
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.
Aaron Bertrand announces the recipient of his third annual Community Influencer of the Year award.
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 […]