Below is the script used in the video demonstrating Resumable online indexes feature in SQL 2019.
Tuple Mover Basics and the Updateable Columnstore index
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 […]
The Key didn’t match any rows in the table – PowerBI
When you get the below error it usually has nothing to do with primary keys or rows. In fact the majority of the time it is because you […]
A Case for Classroom trainings
Every once in a while I see an post on LinkedIn about companies that conduct online Trainings. Each time I see such ads I am reminded of how […]
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. […]
Error on WebAPI after deployment to Azure App Services
Encountered this below error today while deploying a WebApI to Azure App Services. Initially it wasn’t very clear what the error was about so we checked the bin […]
XML Validation: Declaration not found for element Error Message
Often when working with XML data type we encounter issues with the schema validation for the incoming XML. SQL Server does allow us to have XML datatype without […]