BLOG | pigeonsql

Filip Holub

Dec 10, 20193 min read

Downgrade SQL Server edition by In-Place method!

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

9,578 views0 comments

Filip Holub

Mar 7, 20191 min read

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

323 views0 comments

Filip Holub

Jan 13, 20192 min read

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

261 views0 comments

Filip Holub

Jan 10, 20191 min read

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

207 views0 comments

Filip Holub

Jan 8, 20191 min read

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

152 views0 comments

Filip Holub

Jan 6, 20192 min read

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

324 views0 comments

Filip Holub

Dec 19, 20182 min read

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

1,992 views0 comments

Filip Holub

Dec 17, 20181 min read

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

143 views0 comments

Filip Holub

Dec 14, 20181 min read

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

203 views0 comments