Sparse Columns and Column Sets in SQL Server 2008

Sparse columns optimize data storage for null values in SQL Server 2008. Column Sets are used in relation with sparse columns for a very cool new feature. This video introduces you to sparse columns and column sets in SQL Server 2008.

Plamen Ratchev has over two decades experience in the software architecture and development field. He has enjoyed building solutions for UNIX, DOS and Windows platforms, with main focus on SQL Server since version 4.21. Plamen is founder of Tangra, specializing in relational database applications analysis, implementation, and tuning. His particular interest is in design patterns, performance a...

Michael Radlauer on 1/2/2009

Extremely informative.

Ed Svastits on 2/6/2009

Great explanation. Clear and to the point.

Carla Wilson on 2/6/2009

Very interesting topic, especially using columnset to populate sparse columns.

luther smith on 2/6/2009

Nails it.

gaytri on 2/10/2009

Nice tutorial.

Kishore Babu. Peddi on 6/11/2009

Good

Joe on 6/17/2009

It was very informative and precise.

Juri Kirillov on 10/30/2010

nice piece of sql-wisdom, thanks!

Bryant Byrd on 3/10/2011

I didn't really know what sparse columns were, much less when/how to use them, until I watched this video. It answered all the questions I didn't even know to ask.

Talha on 7/13/2011

very useful

suvankar on 7/13/2011

great video

revanth on 7/13/2011

excellent

Jason P. on 7/13/2011

Excellent overview on an interesting group of features, those of us who never got any TSQL training after SS2000 really appreciate your site!

CECity.com on 7/13/2011

very informative, short, and to the point.

Omair on 7/13/2011

I rated this good mainly because the implementation of this doesnt make sense. The example could have been better. Regardless the video was very informative.

MInxia on 7/13/2011

pretty good

borjonx on 7/13/2011

Good XML INSERT example - thx!

ranga rao on 7/13/2011

excellent information about sparse columns

Richard Scott on 7/13/2011

I can't speak to it authoritatively (ahead of my skill level) so I felt I couldn't rate it at 5 to offer critique. It was comprehensive in theory and execution.

Maurice Ivory on 11/22/2011

This video was good stuff, I learned a thing or two.