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.
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.
In this blog post, we are going to talk about how to undo human errors in SQL Server with the help of Point in Time Recovery. Let us learn today.
A very interesting puzzle, where you see the data type conversion in action. I have previously blogged about this puzzle and had received amazing feedback.
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.
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.