Can a single column and single row result do an entire table scan? I recently got this question in my Comprehensive Database Performance Health Check.
How to Insert Multiple Values into Multiple Tables in a Single Statement? – Interview Question of the Week #290
Question: How to Insert Multiple Values into Multiple Tables in a Single Statement? One of the most popular questions, I often receive from my client.
Do MAX(col) Scan Table? – SQL in Sixty Seconds #106
While working on working on a Comprehensive Database Performance Health Check my client asked me – Do MAX(col) Scan Table? Let us learn about that today.
SQL SERVER – Live Query Statistics – SQL in Sixty Seconds #104
The biggest challenge is to know about the queries current execution status. In this video, we are going to see the details about Live Query Statistics.
Do MAX Function Scan Table? – Interview Question of the Week #289
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.