During the recent consulting engagement, I ended up a very interesting situation where I had to drop all the auto created statistics.
How to Measure Transactions Per Seconds in SQL Server? – Interview Question of the Week #262
Question: How to Measure Transactions Per Seconds in SQL Server?
I have updated the script for this for Comprehensive Database Performance Health Check.
What are Different Methods to Know the Row Count of Table? – Interview Question of the Week #261
Question: What are Different Methods to Know the Row Count of Table? The answer to this question is very simple and many.
Lightweight Query Profiling: Live Progress Without the Old Overhead
Use lightweight query profiling to inspect live operator rows and in-flight plans, while avoiding misleading progress percentages.
SQL SERVER – List All the Nullable Columns in Database
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.
Missing Index Suggestions: Three Checks Before You Create One
Review missing index suggestions against existing indexes, key order, and INCLUDE size before adding extra write overhead.