Monthly Archives: September 2018

SQL 2019:- sp_estimate_data_compression_savings

By | September 26, 2018

This procedure allows us to estimate the potential space savings on a table before we apply a compression algorithm. It’s not exactly a new feature of SQL 2019 because it was also available in SQL 2017 however it now provides information on Columnstore indexes as well. The reason why this is important is because we… Read More »

SQL 2019:- sys.dm_db_page_info

By | September 26, 2018

  So we have a new DMF to allow us to view details for the page something I do very often during trainings using the DBCC Page Utility. I figured this DMF would be pretty useful since I can be queried and joined with sys.dm_db_database_page_allocations to provide some interesting insight on the underlying pages mapped… Read More »

SQL 2019:- APPROX_COUNT_DISTINCT

By | September 25, 2018

  A function that might prove useful when querying very large datasets, it provides a count of distinct values for any column in the database except text,ntext , image data types. Why would this be useful? In many cases we see that an approximate count of the rows is sufficient and we don’t really need… Read More »

To accomplish this action, set property PartitionScheme

By | September 25, 2018

SSMS 18.X error when creating NonClustered index This seems to be a bug in SSMS as the index can be created using TSQL just fine here is the full error message. TITLE: Microsoft SQL Server Management Studio ——————————   Exception has been thrown by the target of an invocation. (mscorlib)   —————————— ADDITIONAL INFORMATION:  … Read More »

Installing SQL 2019 CTP 2.0

By | September 25, 2018

It’s finally out and it’s going to be awesome but there is only one way to find out, so here is the very first step, installing SQL SERVER. The trail version CTP 2.0 can be downloaded from the below link. You have four different installers. https://www.microsoft.com/en-us/sql-server/sql-server-2019 SQL for Windows SQL for Linux SQL in Docker… Read More »