There are so many different statuses of the processes in SQL Server. Let us learn today the difference between Sleeping vs Suspended Process.
When was Stored Procedure Last Compiled? – Interview Question of the Week #292
Question: When was Stored Procedure Last Compiled?
Answer: Honestly, it is difficult to figure out when was the stored procedure last compiled.
Full-Screen Execution Plan – SQL in Sixty Seconds #117
There are two primary tools – 1) Execution Plan and 2) Statistics IO. In this blog post, we will see how we can get the full-screen execution plan.Â
Execution Plan – Estimated vs Actual – SQL in Sixty Seconds #113
During the Comprehensive Database Performance Health Check, I often get the question about Estimated vs Actual Execution Plan. Let’s discuss.
Single Column Single Row and TABLE SCAN – SQL in Sixty Seconds #111
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.
Dirty Read with NOLOCK – SQL in Sixty Seconds #110
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.