Vardecimal Storage Format and its implications on Backup/Recovery

Has any one tried restoring or attaching a SQL Server 2005 database on SQL Server 2000? You will find that SQL Server 2000 will fail this restore or attach. The reason is simple. SQL Server 2000 does not understand the physical structure changes in SQL Server 2005 database. SQL Server detects this incompatibility using the… Read more

More undocumented fun: DBCC IND, DBCC PAGE, and off-row columns

(Final blog post of the year for me. Its been a bit of a wild ride the last 6 months – 7 TechEds on 3 continents, 46 blog posts and some major life changes – but now things have calmed down and I should be back to more regular posting in 2007. Tomorrow I fly out to… Read more