In the course of our interviews at the PASS Summit 2009 this month, we managed to snag four top-level SQL authors and educators at once, in the same room. (Actually, in the same 8’x8′ space, but who’s counting.) In Part 2 of our series “Buck, Paul, Joe, and Louis”, we have an absolutely wonderful talk […]
Category: Uncategorized
Notes on Activity Monitor and Resource Locks
We had a big system slowdown today, and one of the things I did was to open up Activity Monitor (in SQL Server MS 05, it’s under Management in the object explorer) and take a look at blocking. One of my blocked SPIDs showed this in the Resources column: TAB 12:1957582012:0 I know TAB means […]
Quick Reference: Job Steps
There are other ways to do this, but the quick n easy way for me to get job and job step information is Get job names using EXEC msdb.dbo.sp_help_job Paste those names and surround them with single quotes, and preface each with EXEC msdb.dbo.sp_help_jobstep @job_name= ‘ Hit CTRL-T for “results to text”. (This makes it […]