Home Forums Article Discussions Article Discussions by Author Discuss content posted by Rajeev Ramadugu Sparse Columns RE: Sparse Columns

  • February 20, 2009 at 11:18 am

    #947726

    Lisa Phillip (2/20/2009)

    Sparse columns REDUCE the space needed not negates: Sparse columns reduce the space requirements for null values at the cost of more overhead to retrieve nonnull values.

    http://msdn.microsoft.com/en-us/library/cc280604.aspx%5B/quote%5D

    Yep. I got caught by this one too. The answer is incorrect.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning