Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server 2005 Expand / Collapse
Author
Message
Posted Thursday, August 13, 2009 10:35 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, January 14, 2014 8:44 PM
Points: 1,520, Visits: 739
Comments posted to this topic are about the item SQL Server 2005

Thanx.
Vinay


http://rdbmsexperts.com/Blogs/
http://vinay-thakur.spaces.live.com/
http://twitter.com/ThakurVinay
Post #770668
Posted Thursday, August 13, 2009 11:40 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 7:16 PM
Points: 1,538, Visits: 2,587
Thanks. To be frank I was not aware about it.
And I have never seen anybody using it as well.
Post #770689
Posted Friday, August 14, 2009 6:18 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, January 17, 2014 8:45 AM
Points: 289, Visits: 111
And according to BOL is already obsolete. Btw anybody find it useful?
Post #770832
Posted Friday, August 14, 2009 7:35 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, January 29, 2014 2:58 PM
Points: 1,141, Visits: 944
I didn't realize that it was already obsolete up until now. I have tested this for a very large DW and have seen significant disk space savings.
Post #770893
Posted Friday, August 14, 2009 7:58 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 5:59 PM
Points: 31,082, Visits: 15,529
It was introduced for data warehouses and cubes, offering savings if you store significant amounts of decimal data.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #770931
Posted Sunday, August 16, 2009 8:24 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:38 AM
Points: 2,582, Visits: 553
I found it usefull in a large database on a server with many CPU:s and I/0 bottleneck, but now we have replaced it with table compression in SQL server 2008, and it is much more usefull. (We have 4 quad processors :) )


/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
Post #771616
Posted Wednesday, October 28, 2009 6:53 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 4:57 PM
Points: 7,745, Visits: 9,493
It's hard to understand why MS introduced this storage format - perhaps they hadn't yet decided to provide table compression in the next version when they did this (although one would thing SQL2008 was in a pretty advanced stage by the time SQL2005 SP2 content was defined). Using a long format + compression (store the affected tables on a compressed partition in older or less facility-rich SQLServer versions ; use SQL table compression if you have the right SQL version) is going to be far cleaner and give greater savings almost always. Of course if you have a very large very sparse matrix of decimal values, and want to store it in fully expanded form (ie as if it were not sparse) in a table it's possible that vardecimal might do as well as or maybe even better than compression, but (a) I think it's unlikely that vardecimal actually would do better and (b) I really can't imagine anyone wanting to do that.



Tom
Post #809865
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse