I use this to log duration information when I am testing stuff with Sql I find this useful when testing how loing things are taking […]

When attempting to assess the performance of a given script on SQL Server it is quite difficult. The caching of execution plans etc etc, lead […]

I had an interesting problem the other day. Someone ran a sql script I had written on their SQL2005 database and it threw an error […]

The other day I had need to use an unpivot query in SQL 2005. Thought it was really cool so here it is… Assume you […]