The sparse columns feature in SQL Server 2008 is generating lots of interest from people looking to deploy extensible schemas. I've seen a few questions from people that are confused by some of the info in Books Online, particularly about adding and removing sparse columns from a table. There's a section in BOL that states [...]
Paul S. Randal
In Recovery...
Sparse columns: misleading info in Books Online
Posted on: October 19, 2008 3:30 pm
SQL Server 2008: Sparse columns and XML COLUMN_SET
Posted on: April 28, 2008 11:05 pm
We’re sitting here in St. Pete Beach in Florida visiting some of Kimberly’s family and having some sun-kissed R&R before heading back up to Seattle on Wednesday, and I thought I’d get the next post in my sparse columns mini-series out. Before I start though, Kimberly just posted the resources for the Accidental DBA class [...]
SQL Server 2008: Sparse Columns
Posted on: April 18, 2008 1:46 am
It’s been quite a while since I wrote a blog post on a flight but I happened to be playing with a CTP-6 VPC on the way down to Orlando and thought I’d do the first in a few posts on a cool feature of SQL Server 2008 – Sparse Columns. One problem in database schema [...]
