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.
How do I find the open transactions for any session? One of my clients recently asked me during the Comprehensive Database Performance Health Check.
I received a question from a client that they want to move their database from the Full Recovery Model to the Simple Recovery Model, can they do it?
Is it necessary to drop a temp table created in the stored procedure? I was recently asked this question during the Comprehensive Database Performance.
One of my client of Health Check recently asked me if I can help them understand how FORCE DEFAULT CARDINALITY ESTIMATION works
Temp stored procedures are the SPthat are created with the help of the # at the beginning of the name and only available until the SQL Server restarts.