Monthly Archives: December 2019

Script on how partitioning can improve performance

By | December 23, 2019

In this post I have pasted the script used in the Youtube video on how Partitioning can improve query performance. [codesyntax lang=”tsql”] USE MASTER GO — THIS SCRIPT WILL TAKE TIME TO RUN , PLAN ACCORDINGLY. — CUP OF COFFEE IS OPTIONAL BUT HIGHLY RECOMMENDED. —CREATE A DATABASE TO PLAY AROUND WITH — MAKE SURE… Read More »

How WITH (NOLOCK) can degrade performance

By | December 11, 2019

I was recently asked by a company to have a technical call for a training requirement. The “Senior Database Architect” insisted I only talk about concurrency issue. I tried to explain that concurrency is just one aspect of tuning and using some features are a double edged sword. As an example I wanted to show… Read More »

SQL 2019 – Christmasql

By | December 4, 2019

Early November I had posted I would be conducting a series of sessions on MS SQL server. The response was really great and while I intended to do a classroom session the interest was primarily for online delivery. So I will be arranging the first half of it this in the coming 10 days. Here… Read More »