April 1, 2014 at 7:23 am
Where can I get detailed notes on "Data compression in SQL server"?It would be helpful if the notes are accompanied with examples.
April 1, 2014 at 9:10 am
This might help as well...
Note: Read comments as well in the post.
April 1, 2014 at 9:31 am
gstarsaini (4/1/2014)
Where can I get detailed notes on "Data compression in SQL server"?It would be helpful if the notes are accompanied with examples.
Check this one ..
http://msdn.microsoft.com/en-us/library/dd894051(SQL.100).aspx
--
SQLBuddy
April 3, 2014 at 1:07 am
Hello,
I think SQL Server 2012 supports row and page compression for tables and indexes. You can use the data compression feature to help compress the data inside a database, and to help reduce the size of the database. In addition to saving space, data compression can help improve performance of I/O intensive workloads because the data is stored in fewer pages and queries need to read fewer pages from disk. However, extra CPU resources are required on the database server to compress and decompress the data, while data is exchanged with the application. Data compression can be configured for the following database objects:
A whole table that is stored as a heap.
A whole table that is stored as a clustered index.
A whole non clustered index.
A whole indexed view.
For partitioned tables and indexes, the compression option can be configured for each partition, and the various partitions of an object do not have to have the same compression setting.
Hope the answer will be helpful!
For more information, you can contact this ID: Info@ForerunnerSW.com
http://forerunnersoftware.blogspot.in/2014/03/create-project-with-sql-service.html
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply