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?
SQL SERVER – Enable Lock Pages in Memory LPIM
In this particular case, we had memory issue and after careful investigation, we found the troublemaker as a Lock Pages in Memory settings.
SQL SERVER Management Studio 18 – Enable Dark Theme
We are all techies and we love to use a dark theme in our IDEs. I get quite often a question about how to enable dark theme in SQL Server Management Studio.
SQL SERVER Management Studio – Completion Time in Messages
When the queries end, we know how long the query ran from the duration of the query but we never know their completion time.Â
SQL SERVER – Find All Tables Containing Specific Column Name
During the recent Comprehensive Database Performance Health Check, I was asked if I know any trick to identify column with a Specific Name in the database.