SqlServerKudos - Make huge space savings by using SPARSE columns

Welcome!

SqlServerKudos is a place where you can find the latest SQL Server stories and articles to improve your skills and share your opinions.

Enjoy participating in this community and see which others are getting Kudos.

1
kudos

Kudos

Make huge space savings by using SPARSE columns

published 512 days, 7 hours, 25 minutes ago posted by

sa 521 days, 10 hours, 5 minutes ago

Make huge space savings by using SPARSE columns

I’ve blogged before about Getting more than 1024 columns on a table , this is done by using sparse columns. Whilst this is potentially useful for people with insane table designs, sparse columns aren’t just for this. My experience over the past few years...(read more)

category: News | clicked: 0 | | source: sqlblogcasts.com | show counter code

tags: Performance, SQL Server 2008, SQL Server 2008 R2, storage

Border color:

Kudos Backcolor:

Kudos Forecolor:

Count Backcolor:

Count Forecolor:

Preview

SqlServerKudos