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.
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.
The question was about is there any way we can see SQL Server Execution Plan in Azure Data Studio. Comprehensive Database Performance Health Check.
I received a very interesting question from my client. The question was about how to list all the Memory Optimized Tables in TempDB.
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.
I suggest that you try out my Free Video Courses Analyzing SQL Server Query Plans while we work from home this April 2020.
I also discover new aspects of SQL Server. One of DBA recently asked is there any way to capture the execution plan for the canceled query.