How do I find the open transactions for any session? One of my clients recently asked me during the Comprehensive Database Performance Health Check.
Is it necessary to drop a temp table created in the stored procedure? I was recently asked this question during the Comprehensive Database Performance.
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.
Question: When was Stored Procedure Last Compiled?
Answer: Honestly, it is difficult to figure out when was the stored procedure last compiled.
My clients were not sure which SPs are the recent SP and which SP is no longer used. Today we will learn about the recent execution of the stored procedure.
They had one transaction which was often the victim of deadlock. Today how to Reduce Deadlock for Important Transactions With Minimum Code Change.
Recently during the Health Check, I had a great conversation about how to disable Parameter Sniffing and DISABLE_PARAMETER_SNIFFING Query Hint.