Wait Stats Library

Every so often you come across one of those tools that just changes everything. When it comes to troubleshooting tools, this is one of those defing tools. Paul Randal has assembled the greatest library of SQL wait statistics known to man – well to me anyway. If...

DateTime2 not like DateTime

I came across an article on SQL Server Central written by Claudio Silva (b/t) discussing that you can’t do arithmetic operations on DateTime21 like you can with DateTime. For example: Old Way Transact-SQL OrderDate < GETDATE() -1 1 OrderDate < GETDATE() -1...

A Month of SSMS

One of the things that has always frustrated me with Microsoft’s tools like SSMS and Visual Studio, is the sheer depth of the tool. Figuring out how to create an SSRS or SSIS package in Visual Studio the first few times can result in half a day wasted. SSMS can...

SQL version numbers

This is one of those tools I use all the time. I’m always looking at the version number to see which version of SQL with SP/CU version I am working with. SQL Version numbers and patch...

Error 18456 State x

I use this link all the time to troubleshoot login errors in the SQL error log. Aaron Bertrand recently moved his blog, so I wanted to make sure I had an updated link for my reference. Troubleshooting Error...

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close