1.

Which of the following compression type is supported by SQL Server 2014?(a) Row(b) Column(c) Both row and column(d) None of the mentionedI had been asked this question by my school teacher while I was bunking the class.Query is from Data Compression in chapter Performance Tuning and Optimization of SQL Server

Answer»

The correct answer is (c) Both row and column

For EXPLANATION: SQL Server 2014 SUPPORTS columnstore and columnstore archival compression for columnstore tables and INDEXES.



Discussion

No Comment Found

Related InterviewSolutions