I should also have included the script for method 1 discussed in the blog post. Let us learn a method of inserting sp_who2 into a table.
SQL SERVER – Representing sp_who2 with DMVs
During the recent Performance Check, I had a very interesting situation where my client wanted to capture the details of the sp_who2 in a table with DMVs.
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 – Convert Formatted Integer Values into Date
One of my clients of Comprehensive Database Performance Health Check asked me a question about how to Convert Formatted Integer Values into Date.
SQL SERVER – Change Database and Table Collation
Recently I was helping my client with a health check and we walked into a very interesting scenario. We had to change the database collation.
SQL SERVER – Writing Infinite Loop
We had to write a loop that runs continuously at every one second and captures the details. Let us learn how we can write an infinite loop.Â
SQL SERVER – Query Shortcuts
One of my clients who hired me for the Database Performance Health Check got very impressed that I was able to use efficiently query shortcuts.