asked
how we can save the space using sparse columns in sql server 2008 r2
Can any one tell how we can save the space using sparse columns in sql server 2008 r2? I have googled but not clear for me the logistics behind this. Please tell how I can use this in my database.
Are you confusing "saving space" with "not using space"? Creating a table that has columns that contain sparse data simply wont use as much space as a table that doesnt have that feature. If you move a table from non-sparse to sparse then you would see the table size decrease. The whole database size however is unlikely to decrease as the files wont have been resized. There is more room within them for the database to grow before they need to resize.
9 People are following this question.
