Monthly Archives: February 2011

When I Drop a Database, Why Does 1 Or More Files Still Exist?

This is a quick post about an issue we have encountered a couple of times when drop a database and one or more files appear to be left over for some time afterwards. This time, we found the culprit! Essentially, … Continue reading

Posted in SQL Server Issues | Tagged , , , , , | Leave a comment

A Little Fun With DateTime

A colleague asked me how to get the last day of the month for the current month using T-SQL. It’s an interesting problem, myself and another colleague both gave different answers to his question (which just goes to show that … Continue reading

Posted in T-SQL Code Examples | Tagged , , , , | Leave a comment