Question: How to Capture Deleted Rows Without Trigger?
Answer: I was recently asked by my client during the Comprehensive Database Performance Health Check.
Priority Boost and Performance – SQL in Sixty Seconds #131
Enabling Priority Boost does not mean that you get performance from your SQL Server. It may be quite opposite. SQL in Sixty Seconds.
SSMS Efficiency – Replace STAR – SQL in Sixty Seconds #130
You might have heard that SELECT * is bad for queries performance. Let us learn in today’s video how we can replace STAR (*) by column name.
How to Change Database File Size? – Interview Question of the Week #296
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.