Subscribe to:
Posts (Atom)
Table size and rows of tables in sql server
Below query will help us, to know tables size and now of rows in a table. SELECT SCHEMA_NAME(t.schema_id) AS SchemaName, t.name A...
-
-- Health and status of WSFC cluster. These two queries work only if the WSFC has quorum SELECT * FROM sys.dm_hadr_cluster SELECT * FROM sy...
-
Issue: The SQL Server service for our cluster could not be brought online during a recent failover due to registry not found error(s). How...
-
Have your SQL queries been eating up CPU like it's a buffet? Then it’s time to talk about the most underrated setting in SQL Server: ...
