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.