Interview Questions
1. What is data compression in a SQL server database?
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.
Submit an interview question
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment