There are two primary tools – 1) Execution Plan and 2) Statistics IO. In this blog post, we will see how we can get the full-screen execution plan.
Activity Monitor and Running Query – SQL in Sixty Seconds #115
Activity Monitor can come handy when you are in trouble as well. We will see how we can take the help of Activity Monitor to track Actively Running Query.
Email an Execution Plan – SQL in Sixty Seconds #114
Today we are going to learn how we can send Email an Execution Plan. In the video, I explain how one can send query plans via an email.
Execution Plan – Estimated vs Actual – SQL in Sixty Seconds #113
During the Comprehensive Database Performance Health Check, I often get the question about Estimated vs Actual Execution Plan. Let’s discuss.
Single Column Single Row and TABLE SCAN – SQL in Sixty Seconds #111
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.