Live Query Statistics in SSMS draws a query plan that moves while the query runs, with a percentage beside each operator. This post tests a query with a wrong estimate on SQL Server 2025 and explains what the percentage means, why a Sort sits at zero, and how it differs from the cost percentage.
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.
Negative Identity Column – SQL in Sixty Seconds #101
I had a very interesting story to tell about a negative identity column from my recent Comprehensive Database Performance Health Check.
Keyword Join or Inner Join – SQL in Sixty Seconds #099
Have you ever wondered what is the difference between keyword Join or Inner Join? Are they same or different? If different, how are they different?
Where are Table Variables Stored? – SQL in Sixty Seconds #095
A very popular question we will answer today Where are Table Variables Stored? Recently I have posted a few videos on my YouTube Channel,
Creating Covering Index to Eliminate Join – SQL in Sixty Seconds #090
How to improve performance so today we are going to see a video about creating converting index to eliminate join and improve query performance.
SQL SERVER – 7 Follow Up Answers to Remove Bookmark Lookup
My video on bookmark lookups brought many questions. Here are 7 follow up answers to remove bookmark lookup doubts, starting with STATISTICS IO overhead.