Today we will see a very simple script that I often use during my Comprehensive Database Performance Health Check. Let us find Total Sessions By Database.
I had a very interesting situation where I had to find all the threads which are not counted for max worker threads in SQL Server. Let us see the script.
In this blog post, we will be discussing a very interesting scenario of Trigger on Database to Prevent Table Creation. Let us learn today.
Earlier I had written a blog post SQL SERVER – List Tables with Size and Row Counts. Jason Horner, an SQL Server Expert, improved my query.