Browse by Tags

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

• 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 | 3 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 01, 2008 12:19 PM by Andrew Kelly | 6 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 | 22 Comments Filed under: TSQL, Bugs