|
Comments
|
|
Sparse + XML = excellent!
|
|
|
nice. good approach
|
|
|
cool new feature. excellent presentation(succinct)
|
|
|
Why have descrete columns if the table has a XML column set. Why not just use the XML and remove the individual columns?
|
|
|
I didn't get a good sense of how to use this. I would like a little more detail.
|
|
|
Good video and working example.
|
|
Terry Grignon on
9/25/2009
Doesn't really show a practical application for sparse columns
|
|
|
There was a word I couldn't understand -- played many times over. Maybe get a layman to listen prior to deployment as a techie may know the jargon and "hear" and comprehend regardless. Just a thought...
|
|
|
His accent is pretty strong, so it's a little difficult to understand.
|
|
|
Paul Nielsen, in his recent SQL server 2008 Bible, says thta anyone using sparse columns in his database design, should resign and get a job flipping burgers. I know h's kind of drastic, but I like the guy and his opinions on SQL, so I think I will discard this video...
|
|
|
Johnny, in many cases there is a need to work with simple SQL statements affecting only a couple columns. Using the XML column set will be inefficient, it is mostly for bulk management of the sparse columns.
|
|
|
Don, the following article provides more details on using column sets with sparse columns: http://technet.microsoft.com/en-us/library/cc280521.aspx
|
|
|
Terry, good examples of using sparse columns are SharePoint (where users can create dynamic tables on the fly with many columns) and a survey application (where many columns for particular survey may not have values). In those cases there can be significant space savings by using sparse columns. Here are more details: http://technet.microsoft.com/en-us/library/cc280604.aspx
|
|
|
Stéphane, to discard a new technology does not make sense. It is fine if you do not want to use it, but there are many practical uses. I already provided example with SharePoint, which has to allow users to create large dynamic tables with many columns. An alternative would be to use EAV, which in my opinion is a worst design implementation (cannot verify domain types, not to mention complexity of querying, etc.). And in essence a table with sparse columns is just like any other table, design is the same. It only offers space saving if there are expectations for large quantity of NULLs in the data.
|
|
|
Accent of speaker very strong and difficult to follow!
|
|
Ahmad Elayyan on
9/27/2009
v.good
|
|
|
You've got to make the source code bigger, so we can read it without straining.
|
|
|
Good post.... Thanks a lot...
|
|
|
Nice
|
|
Jamshid Nouri on
1/26/2011
great demo
|
|
Emine Dekkar on
1/26/2011
Great job Plamen! I now understand when and how to use it thx, indeed you mentioned 2 good scenarios, I would add to that a multi-use logging table for ETL or webservices activity where each one may need it's own set of columns and yet use other common ones.
|
|
|
interesting little piece of info, person was a little hard to understand though.
|
|
Philip Hickey on
1/26/2011
Thansk you for covering this new feature - nice presentation
|
|
Kris Robinett on
1/26/2011
Something I did not know existed.
|
|
Carla Wilson on
1/26/2011
Awesome! Thanks for introducing me to Column-sets!
|
|
|
video can not see until finish,i'm not sure what problem
|
|
|
It is difficult to understand this guy with that accent!
|
|
|
never thought about this and cool to see this. does it work with merge too?
|
|
|
Too strong of accent, and talk too fast.... Plus the video is meaning less, and no particualr explanation why we should use this column sparse
|
|
|
Mark, yes - you can use the MERGE statement to manipulate column sets.
|
|
|
not quite clear in its explanation.
|
|
|
It was okay...but I ned more understanding about the subject
|
|
|
Cannot understand due to his accent.
|
|
|
Illuminates a very useful and obscure sounding new 2008 feature.
|
|
|
thank you
|
|
|
Good presentation.
|
|
|
I would like to see more about WHY we would want to use a sparse column. This seems like a denormalized db to me.
|
|
|
would like to see you amplify on Sharepoint interaction
|
|
|
Excellent
|
|
|
Excellent
|
|
|
Unbearable accent
|
|
|
I had no idea that there was this functionality...very cool!
|
|
|
I appreciate the info. I'm just trying to figure out how having to formate and produce the XML works out to being less cumbersome than doing it the old fashion way. I guess I need some real world examples to better illustrate the point.
|
|
Brett Phipps on
2/17/2012
Kinda cool feature that I may use in the feature. Well presented and explained.
|
|
|
Good
|