Today we are going to discuss how we can change the configuration value of the Boost SQL Server Priority with SSMS version 18 onwards.
SQL SERVER – 3 Ways to Know Count of TempDB Data Files
Comprehensive Database Performance Health Check, and it was about the tempDB. Let us learn today 3 Ways to Know Count of TempDB Data Files.
SQL SERVER – Wait Statistics from Query Execution Plan
Recently one of my clients asked if I know a way to find the Wait Statistics from the Query Execution Plan. Yes, there is a way to do it.
SQL SERVER – User Statistics Report for Database – SSMS
Once we isolate the user, it was easier for us to get the performance back to the original level. Learn about User Statistics Report for Database – SSMS.
SQL SERVER – Open SSMS from Command Prompt
Recently one of my clients asked me if I know any way to open SSMS via Command Prompt. Of course, it is possible to do that in Windows.
Azure Data Studio – Explain SQL Server Execution Plan
The question was about is there any way we can see SQL Server Execution Plan in Azure Data Studio. Comprehensive Database Performance Health Check.
Azure Data Studio- Export Any SQL SERVER Query As JSON
Recently, one of my clients’ Comprehensive Database Performance Health Check asked me if I know a way to export any query as JSON with SSMS.