During the recent consulting engagement, I ended up a very interesting situation where I had to drop all the auto created statistics.
Question: How to Measure Transactions Per Seconds in SQL Server?
I have updated the script for this for Comprehensive Database Performance Health Check.
Question: What are Different Methods to Know the Row Count of Table? The answer to this question is very simple and many.
Recently during the consulting engagement, I needed to create a query that Lists All the Nullable Columns in Database, which I am sharing.
How to Determine Read Intensive and Write Intensive Tables in SQL Server? – Interview Question of the Week #251
Question: How to Determine Read Intensive and Write Intensive Tables in SQL Server?
Answer: The script is very simple and lets us see in the blog.
Recently I had to work with a client for whom I have to build a script for Listing All Memory Optimized Files with Logical Name and Physical Name.
During the consultation, one of the questions was is there any way to see the information about the partition for any database.