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 – 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.
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.
SQL SERVER – Table Variables or Temp Tables – Performance Comparison – SELECT
Today we are going to discuss the performance comparison of table variables and temp tables when we are running SELECT queries.
SQL SERVER – Check for Update in SSMS
DBAs and Devs had many interesting questions during the Comprehensive Database Performance Health Check. How to check the update in SSMS?