Recently I noticed that my client has been using the WITH NOLOCK hint with their queries and expecting that it will improve the queries performance.
Move TempDB for Performance – SQL in Sixty Seconds #107
we figured out that they had slow overall performance because they had TempDB located on the slow drive. Today we will learn how we can move TempDB.
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.
Rollback TRUNCATE – Script – SQL in Sixty Seconds #105
One of the most popular questions, I keep on receiving is that – Is it possible to Rollback Truncate operation? The answer is YES.
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.
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.