The client wanted to know if the index help with the DELETE command as well. The answer is yes, Indexes do help with the DELETE statement.
SQL SERVER – Not Auto-Updating Statistics with STATISTICS_NORECOMPUTE
After careful investigation, we figured out the cause for not auto-updating statistics. Let us learn about that today with STATISTICS_NORECOMPUTE.
SQL SERVER – 7 Follow Up Answers to Remove Bookmark Lookup
I have received lots of questions based on this question about how to remove bookmark lookup. I have taken the 7 most asked questions and decided to answer.
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.
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.
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.