Question: How to Change Database File Size?
Answer: By Shrinking the files. Now, many have a negative opinion about Shrinkfile.
Nested Transactions are Myth – SQL in Sixty Seconds #125
Many sent me an email that they want to know more about the nested transactions. Let us learn about them in today’s blog post.
Dropping Temp Table in Stored Procedure – SQL in Sixty Seconds #124
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.