Tag Archives for " SQLServer "

Feb 16

Shrinking Database Files – Let’s Not And Say We Did

By Lori Brown | Advice , Beginner , SQL Administration , SQL Server

— by Lori Brown  @SQLSupahStah I recently ran into someone who swears that shrinking database files on a production server is a good thing and proudly said they did it on all systems they work on.  OMG!!  Let me post a quote directly from MSDN regarding weather or not shrinking database files causes fragmentation (https://msdn.microsoft.com/en-us/library/ms189493.aspx) […]

Continue reading
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


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