SQL Server 2008
How to determine the current database context in SQL Server
I like to run a check script I’ve crafted that tells me stats on the database before I upgrade and perform schema changes. To make the script more universal, I wanted it to report the name of the database the stats are for (for printing purposes). I knew how to check the database server hostname [...]
Categories: SQL Server, SQL Server 2005, SQL Server 2008
SQL server date formats
How many different ways are there to format a date/time? Too many. Here is a list of formats and the specific command to get them: http://www.sql-server-helper.com/tips/date-formats.aspx
Categories: SQL Server 2005, SQL Server 2008