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.
SQL SERVER – Offline, Detach and Drop – Differences – SQL in Sixty Seconds #103
if I can help them understand the difference between database status like Offline, Detach and Drop. It was very important to differences.
Are Not Equal to Operators Equal to Not In? – SQL in Sixty Seconds #102
What I love most about my job, is that I get to work with different people and answer questions. Are Not Equal to Operators Equal to Not In?Â
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.Â