Question: How to Generate Script for SQL Server 2005 from SQL Server 2019?
Answer: Actually, I got this question from my client.
SQL SERVER – Boost SQL Server Priority and SSMS 18
Today we are going to discuss how we can change the configuration value of the Boost SQL Server Priority with SSMS version 18 onwards.Â
Identify Index Used for Query – SQL in Sixty Seconds #088
Let us see in today’s SQL in Sixty Seconds video how one can identify the index used for the query a popular question asked in Health Check.
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 – List All Active Background Jobs
During Comprehensive Database Performance Health Check, we had an issue where lots of active background jobs consuming lots of important resources.Â
Personal Technology – Solution – Bluetooth KeyBoard and Mouse Frequently Disconnecting
Today we are going to look at how we can fix the issue about frequently disconnecting with your Bluetooth devices like keyboard and mouse.
SQL SERVER – View Percentage Completed for A Long Executing Query
During the consultation, we needed to check the status (View Percentage) of the few queries and for that, I quickly wrote a query which we will see today.