DBCC & DMVs

How to Enable, Disable or Check SQL Server Trace Flags?

Trace flags are used to gather in-depth information about certain logs during some transactions. We use DBCC commands to enable…

4 Different Usages of DBCC SQLPERF in SQL Server

DBCC SQLPERF is very useful command that we use to get multiple statistics related information in SQL Server. This command…

Should We Clear Wait Statistics Data from DMV sys.dm_os_wait_stats in SQL Server?

Should we clear or reset Performance Wait Statistics Data present in DMV sys.dm_os_wait_stats in SQL Server? The answer to this question is depends…

Why is table row count showing incorrect value in sys.partitions or in DMV sys.dm_db_partition_stats

Last week, I had a requirement to check the row counts of all the tables present in a database. I…

How to Get Row Count of All Tables of a Database

Last week, I had a requirement to check the row count of all tables having a specific schema of databases.…