Subscribe to:
Posts (Atom)
SQLDBA - create the temp db files dynamically
Below script will be help full for creating temp DB files for specified count DECLARE @tempdbfilecount INT; DECLARE @tempdatadir ...
-
-- 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: ...
