Our analysis of Page Compression has shown that using it can bring substantial benefits to Fast Stats People Stage and reduce the size of data and indexes by over 60%.
There will be an additional CPU load to handle the compression/decompression but this is usually compensated for by the reduced I/O.
SQL Server 2016 introduces the temporal table (also known as ‘system-versioned’ temporal table) feature to store history of data changes in a table so that you can travel back in time and get the data that represents a past state in time.
In the last article of the series, I discussed this new feature, how it works, considerations and limitations to keep in mind when using this new feature.
These columns can be marked as HIDDEN to hide it from end users.SQL Server 2016 builds upon that work with the promise of even more accurate estimates when you set the compatibility level to 130.However, regressions are possible so you should thoroughly test existing databases before changing the compatibility level in production.The Silent filter predicate means that the application will not be made aware that the data is filtered, null values will be returned if all rows are filtered, without raising an error message.The Block predicate prevents any write operation that violates any defined predicate with an error message returned as a result of the block.