A very common question, I keep on getting is how to get column names for a particular column. Well, it is pretty straightforward and easy to do.
Today we will be seeing a simple solution of Delayed Durability and Flushing Log Files. Comprehensive Database Performance Health Check.
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.