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.
One of the most popular questions, I keep on receiving is that – Is it possible to Rollback Truncate operation? The answer is YES.
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.
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.
I had a very interesting story to tell about a negative identity column from my recent Comprehensive Database Performance Health Check.
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?
A very popular question we will answer today Where are Table Variables Stored? Recently I have posted a few videos on my YouTube Channel,