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 […]
Drawing triangles using SQL Server – Fractals
If you play sports you know how much fun it is to do trick shots every once in a while. Occasionally I find myself with time on my […]
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 […]
Adding CSV files as linked Server Connection
I often get a lot of migration projects where the data needs to port from CSV format into SQL Server. Here is a quick way I achieve it […]
SQL 2019:- Truncation Error message and where it fails
I was wondering if I should even bother checking this feature out since it was pretty obvious what it does and how useful it is. I can’t even […]
SQL 2019:- Table Variable deferred compilation – PART 2
In the last post we ended with two questions remaining unanswered. Shouldn’t a more accurate row count have resulted in the correct amount of memory being granted and […]
SQL 2019:- Table Variable deferred compilation
One of the features being released in SQL 2019 that has got some attention is table variable deferred compilation. As its name suggests it applies to Table Variables […]
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 […]