Post reply

Using Sparse Columns and Sparse Column Sets

  • September 5, 2012 at 7:30 am

    #1533803

    Good Question...!

    Best,
    Naseer Ahmad
    SQL Server DBA

  • September 5, 2012 at 7:35 am

    #1533809

    Good question Wayne learned something about XML Column_Set.

  • September 5, 2012 at 7:35 am

    #1533810

    Nice question. I only got this one right because there was another sparse column question recently that I had to do research on.

    I would be interested in seeing a SSC poll on the usage of sparse columns and sets. I have yet to run across any examples of them in production.

  • September 5, 2012 at 7:39 am

    #1533813

    KWymore (9/5/2012)

    Nice question. I only got this one right because there was another sparse column question recently that I had to do research on.

    I would be interested in seeing a SSC poll on the usage of sparse columns and sets. I have yet to run across any examples of them in production.

    I would also like to see how much they are used!!

  • September 5, 2012 at 8:17 am

    #1533846

    (Bob Brown) (9/5/2012)

    KWymore (9/5/2012)

    Nice question. I only got this one right because there was another sparse column question recently that I had to do research on.

    I would be interested in seeing a SSC poll on the usage of sparse columns and sets. I have yet to run across any examples of them in production.

    I would also like to see how much they are used!!

    I guess that one of the easiest examples to give is... Sharepoint.

    You can upload a document into it. You can specify various properties of that document. For each type of document, only some of the properties are relevant. As you add more properties to handle more document types, the number of irrelevant columns just increase for each type of document. With potentially an unlimited number to the types of documents, each document will have irrelevant properties... yet they are still being dragged around in the row, and they are taking up space. Unless it's a sparse column, which only takes up space if it has non-null data.

    Does this help?

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • September 5, 2012 at 8:28 am

    #1533859

    Yes, Thank you so much Wayne!

  • September 5, 2012 at 8:30 am

    #1533860

    Nice example Wayne. Thanks!

  • September 5, 2012 at 10:40 am

    #1534000

    Good question, I don't have too much experience with sparse columns and/or XML, but definitely learned something new today.

    "El" Jerry.

    "A watt of Ottawa" - Gerardo Galvan

    To better understand your help request, please follow these best practices.[/url]

  • September 5, 2012 at 2:09 pm

    #1534122

    Very good question Wayne. Thanks.

    Sujeet Singh

  • September 5, 2012 at 2:56 pm

    #1534144

    Thanks for a good question wayne

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • September 6, 2012 at 4:26 am

    #1534349

    Great question...................:)

  • September 17, 2012 at 5:20 pm

    #1538851

    good question that I missed but learned from.

    Not all gray hairs are Dinosaurs!

Viewing 12 posts - 16 through 26 (of 26 total)

You must be logged in to reply to this topic. Login to reply