Nicklas Bågvinge sent me a very interesting SSMS tip. Let us learn how we can select vertical text in SSMS using ALT + SHIFT keys.
SQL SERVER Management Studio – Removing Completion Time in Messages
I have received many curious emails and questions while working with clients on Removing Completion Time in Messages. Let us learn them today.
SQL SERVER – 7 Resources From Techorama Netherlands 2019
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 – 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.