Recently during SQL Health Check I had an interesting conversation with Sr. DBA about Stored Procedure Parameters and Single Quotes.
One of my clients of Comprehensive Database Performance Health Check asked me a question about how to Convert Formatted Integer Values into Date.
I have a simple script that will list all the long running queries in the database with the execution plan. Well, the answer is yes.
Today I am going to share our very interesting conversation about sp_updatestats and Disabled Nonclustered Indexes. Let us discuss.