Monthly Archives: January 2014

Do CURSORs work with ORDER BY?

Posted on January 21, 2014 by cms4j

Cursors are not liked by most DBAs, but sometimes they are necessary and for administrative tasks working well. Sometimes you even want to have the set that is iterated in a specific order. Therefore you like to add an ORDER … Continue reading →

Posted in SQL Server | Tagged | Leave a comment

Last “Touch” on each Database per Instance

Posted on January 13, 2014 by cms4j

Today i was asked if some of the databases on a specific instance were in use or not. As this is an interesting question that could be easily answered by the SQL Server DMVs i wrote a little script to … Continue reading →

Posted in SQL Server | Tagged | 1 Comment