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.
During the recent Comprehensive Database Performance Health Check, I was asked if I know any trick to identify column with a Specific Name in the database.
Let us understand how we can quickly identify the workload type of read-heavy or write-heavy by counters. Comprehensive Database Performance Health Check