In this blog post, I will include a few resources which I promised during my presentations at Techorama Netherlands 2019.
SQL SERVER – Drop Multiple Columns from a Single Table
DBA was dropping the unused columns one at a time. I was surprised that he did not know the trick to Drop Multiple Columns from a Single Table.
SQL SERVER – Override Server’s Configuration of Max Degree of Parallelism
One of the interesting question: Is it possible to Override Server’s Configuration of Max Degree of Parallelism? Of course, it is possible, let us read.
SQL SERVER – ColumnStore Indexes Without Aggregation
I suggested that the client can experiment with the columnstore indexes and it may help the performance. Comprehensive Database Performance Health Check
How to Download the Latest SQL Server Docker Image? – Interview Question of the Week #244
Question: How to Download the Latest SQL Server Docker Image? Answer: The command to download the latest SQL Server Docker Image is here:
SQL SERVER – SQL Agent – Job Start Whenever the CPUs Become Idle
Recently I was asked by the customer of Comprehensive Database Performance Health Check about SQL Agent and Job starting whenever CPU Become Idle.
SQL SERVER – Strange Error Related to Alias
They immediately paid for Comprehensive Database Performance Health Check and we got online to look at their strange error related to alias.
SQL SERVER – Unable to Start SQL Server Service or Connect After Incorrectly Setting Max Server Memory to a Low Value
My clients contacted me for whom I assisted installation with health check and backup automation. Today we will discuss about max server memory.
Why Attend 21 Essential Scripts: Performance Tuning for Everyone?
It has been the entire year since I am doing various road tour with my training – 21 Essential Scripts: Performance Tuning for everyone.
SQL SERVER – Script to Get Partition Info Using DMV
During the consultation, one of the questions was is there any way to see the information about the partition for any database.