Comprehensive Database Performance Health Check, and it was about the tempDB. Let us learn today 3 Ways to Know Count of TempDB Data Files.
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.
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.
Just earlier today when we were fixing the performance of a database during, we found a unique requirement to disable statistics update on a table.
They had one transaction which was often the victim of deadlock. Today how to Reduce Deadlock for Important Transactions With Minimum Code Change.
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.