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 » ]