SSG Blog
Insights and news from the SQL Solutions Group.
Recent
An Experiment with Deadlocks
Everything can be fixed with a query hint (*cough* directive), right? If a certain process is consistently causing deadlocks, a simple ROWLOCK hint can be added
Defaults In msdb Database
Today is a day to discuss defaults. It started with the day being TSQL Tuesday and having a topic of “Say No to Defaults.” You
XE Output: Weaning yourself off of SQL Profiler, Part 2
In my last post, I shared a script that will take a running trace and show you the XE events that it relates to, and
Check for Errors First, Part III: The Windows Event Logs
In Part I of Check for Errors First, we discovered how to query the error logs, and filter out the noise to find meaningful errors that
Weaning yourself off of SQL Profiler (Part 1)
In this brave, new world of Extended Events (XE, XEvents), I find myself with a mixture of scripts for troubleshooting issues – some use XE,
SHUTDOWN SQL Server
Recently a friend by the name of Chris Bell (blog | twitter) wrote about an easy way to disrupt SQL Server. That disruption comes in