• Grey Twitter Icon
  • Grey Facebook Icon
  • Grey LinkedIn Icon
  • Grey Google+ Icon

© 2016 - 2019 All rights reserved. PigeonSQL.com | Filip Holub

Pigeon's Blog

MY BLOG AND KNOWLEDGE BASE ABOUT MICROSOFT DATABASES

FilipHolub

SQLServer

MSSQL

SQLServerBlog

MicrosoftDatabases

March 7, 2019

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 pretty easy query that generates store procedure is sp_estimate_data_compression_savings for all user tables.

January 13, 2019

The Microsoft introduced with SQL Server 2019 CTP 2.0 new option in regards to Index Maintenance - Resumable Online Index Create. It allows during creating indexes pause this operation and continue later with RESUME parameter. When we are creating index we have to spec...

January 10, 2019

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 2019? What can we look forward to? There are a couple of interesting new features, new tool and new version of Management Studio....

January 8, 2019

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

January 6, 2019

Deterministic - This type always generates the same ciphertext for any plaintext value. This method supports grouping, indexing, joins point lookups and etc. In some cases, users can guess value of column, such as Gender or State. Randomized - This method is more secur...

December 19, 2018

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

Please reload

Sign Up

AND STAY UPDATED!
Filip Holub
RECENT POSTS

Thursday, January 10, 2019

Sunday, January 6, 2019

Please reload

  • Facebook Social Icon
  • Google+ Social Icon
  • LinkedIn Social Icon
  • Twitter Social Icon