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.
Is it necessary to drop a temp table created in the stored procedure? I was recently asked this question during the Comprehensive Database Performance.
There are so many different statuses of the processes in SQL Server. Let us learn today the difference between Sleeping vs Suspended Process.
I often struggle to remember the changes done to the stored procedure and in this situation, the Split Screen of SSMS really comes very helping.
I will describe in detail a bit later on during this blog post. Today we are going to learn that it is possible to have a nonclustered primary key.