Question: What are Different Methods to Know the Row Count of Table? The answer to this question is very simple and many.
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.
SQL SERVER – Listing All Memory Optimized Files with Logical Name and Physical Name
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.
SQL SERVER – Script to Get Partition Info Using DMV
During the consultation, one of the questions was is there any way to see the information about the partition for any database.
SQL SERVER – Find All Tables Containing Specific Column Name
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.
SQL SERVER – Identify Read Heavy Workload or Write Heavy Workload Type by Counters
Let us understand how we can quickly identify the workload type of read-heavy or write-heavy by counters. Comprehensive Database Performance Health Check