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 years ago
DBCC & DMVs
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…
4 years ago
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…
4 years ago
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…
5 years ago
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.…
5 years ago