Question: Do MAX Function Scan Table to retrieve the data?
Answer: Yes, if there are no indexes to help retrieve data. Let us learn it 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.
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.
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.
SQL SERVER – List All Memory Optimized Tables in TempDB
I received a very interesting question from my client. The question was about how to list all the Memory Optimized Tables in TempDB.
SQL SERVER 2019 – Memory-Optimized TempDB and RESOURCE_SEMAPHORE Wait Type
After looking at the execution plan, I realized it was actually built for a very simple query. Today let us discuss Memory-Optimized TempDB and Performance.
Analyzing SQL Server Query Plans – Work From Home – Free April 2020
I suggest that you try out my Free Video Courses Analyzing SQL Server Query Plans while we work from home this April 2020.