Browse by Tags

• Administration
• Best Paractices
• Bugs
• DBA
• DBCC
• Developer
• Documentation
• Performance
• SQL Server
• Tips & Tricks
• Tips & Tricks
• Utilities

• Finding When Someone Last Ran a DBCC

  The other day someone on Twitter asked how to find out when or who last ran a DBCC FREEPROCCACHE command on their SQL Server instance. Since this is not an unusual request I figured I would post a few examples of how to find DBCC commands or even Read More... Posted Wednesday, June 28, 2017 9:30 PM by Andrew Kelly | 16 Comments Filed under: DBCC, Tips & Tricks, TSQL, Administration

• Stopping Execution of Future Batches

  There is a command that as far as I can tell has been in the product since SQL2008 but I was woefully unaware of. Actually I find many others are unaware as well and hence the blog post. The command is SET NOEXEC which has options for ON or OFF.  Read More... Posted Friday, February 17, 2017 3:09 PM by Andrew Kelly | 11 Comments Filed under: Documentation, TSQL, Developer, Administration

• Updated File & Wait Statistics Procedures

  Please note that I have a newer version of these procedures that you can find here http://sqlblog.com/blogs/andrew_kelly/archive/2015/09/02/revised-file-wait-statistics-procedures.aspx . For many years I have been using a set of stored procedures to capture Read More... Posted Thursday, February 13, 2014 6:23 PM by Andrew Kelly | 2 Comments Filed under: Documentation, DBA, Performance, TSQL, Utilities, SQL Server Attachment(s): FileWaitProceduresFeb132014.zip

• sp_spaceused Alternative

  I don’t know why but for some reason I have never liked using sp_spaceused. It probably started a long time ago when the results were often inaccurate due to the meta data being out of date. I am pretty sure that was fixed somewhere along the line but Read More... Posted Friday, May 17, 2013 5:35 PM by Andrew Kelly | 10 Comments Filed under: TSQL, Tips & Tricks, Utilities Attachment(s): TSQLCODE.ZIP

• Cleaning up Un-Named Defaults

  I just had a situation in which we are automating the comparing of databases and I came across a bunch of Defaults that were never explicitly named. This causes them to get a new name each time you create them and makes it much more difficult to write Read More... Posted Friday, June 26, 2009 1:07 PM by Andrew Kelly | 10 Comments Filed under: Best Paractices, TSQL, Developer, Tips & Tricks

• When a Function is indeed a Constant

  In my last blog post:   http://sqlblog.com/blogs/andrew_kelly/archive/2008/02/27/when-getdate-is-not-a-constant.aspx I mentioned that I ran across a situation in which GETDATE() used in a SELECT statement occasionally returned more than 1 value for Read More... Posted Saturday, March 1, 2008 12:19 PM by Andrew Kelly | 20 Comments Filed under: Documentation, Tips & Tricks, TSQL

• When GETDATE() is not a constant

  A short while ago I was collecting wait stat information at a client and ran across a very peculiar situation that I would like to share. Let me start by saying that for years I have coded with the understanding that when you include a system function Read More... Posted Wednesday, February 27, 2008 11:53 AM by Andrew Kelly | 23 Comments Filed under: TSQL, Bugs