Author: Jen McCown

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 […]

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 […]

At long, long, long last, we have the pix up from the MVP Deep Dives book lauch at SQLPASS!! For those who haven't heard: "Responding to BillG’s MVP Summit challenge to “Do philanthropy where you are,” The SQL Server MVP Deep Dives book is a collaboration of 53 MVPs sharing their expertise and passion for […]