Today we will be seeing a simple solution of Delayed Durability and Flushing Log Files. Comprehensive Database Performance Health Check.
SQL SERVER – Stored Procedure Parameters and Single Quotes
Recently during SQL Health Check I had an interesting conversation with Sr. DBA about Stored Procedure Parameters and Single Quotes.
SQL SERVER – Finding Open Transactions for Session – @@TRANCOUNT
How do I find the open transactions for any session? One of my clients recently asked me during the Comprehensive Database Performance Health Check.
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.
What is Temp Stored Procedures? – Interview Question of the Week #294
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.
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.
Recent Execution of Stored Procedure – SQL in Sixty Seconds #118
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.