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?
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.Â