Miscellaneous Statements

Last Updated On : Thursday, October 19, 2017Miscellaneous Statements: In this post we will discuss the miscellaneous statements or DBCC statements, their functions, and the permissions required to run them are as follows: DBCC dllname (FREE) Unloads a specific extended stored procedure DLL from memory. The user must be a member of the sysadmin fixed […]

Row-Level Compression

Last Updated On : Tuesday, May 26, 2015Row-level compression works by using more efficient storage formats for fixed-length data. Row-level compression uses the following strategies to save space: 1) Storing fixed-length numeric data types and CHAR data types as though they were variable-length data types. 2)Not storing NULL or 0 values. 3)Reducing metadata required to […]