Monthly Archives: January 2017

Jan 19

Find Currently Executing Jobs Running Longer Than 30 Day Average

By Lori Brown | Helpful Scripts , Intermediate , SQL Administration , SQL Server

–By Lori Brown   @SQLSupahStah I needed to update some of our long running job monitoring code to improve it from the version that we have right now. I like this version because it uses msdb.dbo.syssessions (https://msdn.microsoft.com/en-us/library/ms175016.aspx) to validate that a job is actually running. I also wanted to know the percent difference between the current […]

Continue reading
Jan 12

SQL 2016 SP1 USE HINT

By Lori Brown | Intermediate , Performance Tuning , SQL Development , SQL Server , Trace Flags

–By Lori Brown   @SQLSupahStah After installing Service Pack 1 for SQL 2016, I ran across USE HINT and thought I would put out what I could find to document it. Here’s where you find info from Microsoft: https://msdn.microsoft.com/en-us/library/ms181714.aspx and here is a link for all of the bugs that are fixed in SP1: https://support.microsoft.com/en-us/kb/3182545 USE […]

Continue reading
>