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.
There are so many different statuses of the processes in SQL Server. Let us learn today the difference between Sleeping vs Suspended Process.
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.
After careful investigation, we figured out the cause for not auto-updating statistics. Let us learn about that today with STATISTICS_NORECOMPUTE.