Is it necessary to drop a temp table created in the stored procedure? I was recently asked this question during the Comprehensive Database Performance.
25 Recent SQL in Sixty Seconds Video
I have been recording SQL in the Sixty Seconds videos for many years. I would like to share my recent 25 SQL in the Sixty Seconds video.
Sleeping vs Suspended Process – SQL in Sixty Seconds #122
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.