|
Comments
|
|
Some quantitative data on benefits of sparse columns vs non sparse.
|
|
|
The spoken language is not very clear.
|
|
|
Greg, please read the topic Estimated Space Savings by Data Type in SQL Server Books Online. It provides some statistics. Here is the link: http://technet.microsoft.com/en-us/library/cc280604.aspx
|
|
|
A good look at a relatively unknown feature.
|
|
|
Difficult to understand though the thick accent. A solution might be to add a notes area to the viewer that contains the text of what is being said, like closed captioning, Second Audio, or subtitles. Other than that; the content was helpful.
|
|
|
Its nice to see little short videos of new functionality. Thanks.
|
|
Carla Wilson on
1/12/2009
I think the filtered index feature would have been good to show in your code.
|
|
|
Carla, here is a link to video that has discussion on filtered indexes: http://www.jumpstarttv.com/filtered-indexes-in-sql-server-2008_518.aspx
|
|
Jason Willis on
10/29/2010
An example of space saved would make a more complete short.
|
|
Faisal Lodhi on
10/29/2010
Learned SOmething New...thanks,
|
|
|
very nice video
|
|
Charles Rich on
10/29/2010
The guy making the presentation was good, but your regular presenter was a little easier to understand.
|
|
|
Really liked the quiz afterward. The font in the review pane was easy to read.
|
|
|
Never heard of SPARSE columns before. Thanks.
|
|
|
bgfdgfgf
|
|
|
To the point! What about indexing a sparse column - anything special besides the mentioned the WHERE option for the index?
|
|
|
nice..
|
|
|
good
|
|
Charlie Bruno on
10/31/2010
Good topic. At times the speaker was a bit difficult to understand.
Thanks for keeping the rest of us educated, up to date and aware of various SQL Server features.
|
|
|
Good
and New Concepts
|
|
|
Very difficult to under what he was saying because of his thick accent. Sorry...
|
|
|
Doesn't really say how a SPARSE column is beneficial vs. a column that is simply NULLABLE. Is it simply the couple of bytes that a NULL (non-SPARSE) column still requires when the value is NULL, vs. 0 bytes for a SPARSE column?
|
|
|
Content is very good.
But the recording sound is not clear.
|
|
|
Hi Hansjörg, there is nothing special about indexing SPARSE columns. They work very well with filtered indexes because you can easily filter out the NULLs making the index lean and more efficient.
|
|
|
Hi Rob Schripsema, you are correct. The difference between regular NULLable columns and SPARSE columns is that when the SPARSE column has NULL value it takes 0 bytes of storage, otherwise it takes space. On a very large table with many such columns this can make a big impact.
|
|
GParvathesam on
11/1/2010
-
|
|
|
very hard to understand what was being said
|
|
|
Bad.
|
|
|
only theory
|
|
|
some examples would be nice as well as some real-world figures showing just how much space you can gain. Are there no downsides? For example if you insert null but later do add some data to the column with an update, does it take longer than if the column would not have been null in the first place?
|
|
Plamen Ratchev on
11/30/2010
Thierry, the BOL topic for SPARSE columns usage (http://technet.microsoft.com/en-us/library/cc280604.aspx) has some pretty good figures on space saving based on data type and percentage of NULLs. There is some overhead on maintaining and retrieving sparse column values (especially non-NULLs), but should not be significant to cause performance issues.
|
|
|
Yep. I think it would have been even better to juxtapose the number of bytes storing a non-sparse column null requires.
|
|
|
Interesting feature. Not something I would use very regularly though.
|
|
|
Thank for sharing this learning little by little
|
|
|
Very good explanation of sparse columns.
|
|
|
A little more background on the sparse column would have been good...e.g. how do they work "under the covers", why do they take 4 extra bytes of space when there is data, what happens when all 30,000 columns have data? Would it error?
Also, I found the accent of the narrator a little difficult to understand.
|
|
|
How much space does a NULL take in a VARCHAR(30) NULL vs. a VARCHAR(30) SPARSE NULL?
|
|
|
MORE PLEASE
|
|
|
good
|
|
|
Mark Jones, storing a NULL in "VARCHAR(30 NULL" requires at least 2 bytes in the column offset array, while storing a NULL in "VARCHAR(30) SPARSE NULL" requires 0 bytes. Kalen Delaney has a very detailed explanation in the Microsoft SQL Server 2008 Internals book.
|
|
Jason Corley on
1/31/2011
You mentioned about it helping filtered index? I don't quite get it as if the filtered index specifies NOT NULL in the WHERE clause, then only rows that have values will end up in the index. Or do the benefits come from creating the index as it is faster to created with this enhancement?
|
|
|
Jason, correct - when you use filtered index with predicate "column IS NOT NULL" the index becomes very efficient because it includes only real values and excludes NULLs. If you use regular index on the column then it includes the NULLs and it is not as useful/efficient.
|
|
|
I some stuff from this, Especially since my group has started using Sharepoint more and more.
|
|
|
very concise, good video. this was much improved over the Sparse column presentation that used XML in the example
|
|
Maurice Ivory on
5/12/2011
I like this one it can help me out on my current project.
|
|
|
Did not know that! Thanks!
|
|
|
It would have been nice if the performance effects of sparse columns were mentioned.
|
|
|
have not migrated to 2008. but learning more about it is helpful
|
|
|
Needs better description of sparsity and its implementation by MSoft
|
|
|
Needs better description of sparsity and its implementation by MSoft
|
|
|
Besides "being a great new feature of SQL Server 2008," what are the benefits? I'll investigate on my own and appreciate the introduction to SPARSE columns, but it would have been even more useful to get into more about why it's worth adding the SPARE keyword to a column. Thanks!
|
|
|
You talked about indexing differences but didn't show them. An extra 30 seconds would have added a lot of useful/clarifying information.
|
|
|
Excellent tip! Never heard of "sparse" before".
|
|
|
Great job!!!
|
|
|
short and sweet, perfect for this forum. Liked the information about sparse columns not available for certain data types.
|
|
|
Excellent! Did not know about SPARSE. Will need to read up on it.
|
|
|
Could not understand the presenter's English.
|
|
|
Thanks for the video
|
|
Maurice Ivory on
11/10/2011
This one was excellent, since my company has just started using sharepoint
|