When Microsoft introduced Columnstore indexes in SQL server 2012 a key limitation was the table could only be read from and not inserted. While the limitation itself has […]
Adaptive Joins SQL 2017
Imagine writing a query where sometimes you join a handful of rows and other times you process millions—traditionally the optimizer had to pick one strategy up front, often […]
94% Compression???? SQL Server from 1GB to 65 MB
In this video we go about taking data that is little over 1 GB in size and incrementally reducing its size all the way down to 65MB. This […]
SQL 2017 – Minor features
There are a tons of minor improvements of features in SQL 2017 that nobody talks about so I figured before we all get swept up with SQL 2019. […]
administration / Database / Errors / TSQL
Finding candidate keys/Primary keys from data that needs to be imported
This is a continuation from the previous post where we went and inserted data from multiple CSV files into SQL server tables using linked server connection. Often the […]
Tuning SQL Server – Simulating Performance issues
Check out the second video on our series on Tuning SQL Server. After explaining the data model in the first video, where we cover the process by which […]
SQL 2019:- sp_estimate_data_compression_savings
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 […]
SQL 2019:- sys.dm_db_page_info
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 […]
administration / Errors / TSQL
To accomplish this action, set property PartitionScheme
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 […]
Installing SQL 2019 CTP 2.0
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. […]