SQL 2008 shrink log file size with no_log alternative
Microsoft SQL Server 2008 no longer allows you to truncate the transaction log using the no_log syntax. Essentially, Microsoft decided (arguably correctly) that too many people were “abusing” the statement and doing harm to themselves. Read more
SQL Logical Name Change by ALTER DATABASE
Use the following code snippits to identify and rename logical file names in Microsoft SQL Server. Read more
Sql Server 2005 “Login name” is blank after restoring from backup
After restoring a database from a remote server backup, the “Login name” is often disassociated. Read more
Preserving Whitespace FOR OPENXML
Using Microsoft SQL Server 2005, when you read xml data using FOR OPENXML, whitespace characters are replaced with a single space. After digging through the internet for half an hour, I found a couple options. Read more