As SQL Server Administrator you will probably sometimes solve downgrade edition of SQL Server, for example from Enterprise/Standard...

As I wrote, I need to find out for all user tables estimates size for the both types compression, ROW and PAGE. Therefore, I wrote this pret

The Microsoft introduced with SQL Server 2019 CTP 2.0 new option in regards to Index Maintenance - Resumable Online Index Create. It allows

The latest SQL Server 2019 version is SQL Server 2019 (CTP) 2.2 which Microsoft announce at 10.12.2018. What is actually new in SQL Server 2

DDM doesn't support following: Always Encrypted columns Filestream data Computed columns You cannot FULLTEXT index where DDM is implemen

Deterministic - This type always generates the same ciphertext for any plaintext value. This method supports grouping, indexing, joins point

Page Life Expectancy(PLE) - This is number of seconds a when pages will stay in the buffer pool without references. In general, the minimal

So, I wrote little script which based on table sys.database_files where we can find out a couple of informations for example size and name o

QUERYTRACEON 9481 - This hint is used with compatibility level 120 and above for forcing cardinality estimator version 70, which means from