DBA > Job Interview Questions > MS SQL Server DBA Checklist

MS SQL Server DBA Checklist - SQL Server 2008 Co

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

MS SQL Server DBA Checklist - SQL Server 2008 Compression

-- SQL Server 2008, Enterprise Edtition, offers both row and column compression, which can be used to reduce the amount of space data takes up on disk and in the buffer pool, potentially boosting performance.
-- Compression requires the use of additional CPU cycles to implement. Because of this, if your server currently has a CPU bottleneck, then compression should probably be avoided.
-- Compression works best for tables that experience mostly reads. Tables that experience a large number of DML activities should probably not be compressed.
-- Don’t use compression on tables subject to heavy inserts, such as bulk inserts.

(Continued on next question...)

Other Job Interview Questions