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.
SQL SERVER – Computed Column and Compute Scalar Operators
One of my clients recently asked me a very interesting question about the computed column and Compute Scalar Operators. Let us learn about it today.