TSQL Queries Used by SQL DBA in day to day
In this article, we'll explore some of the most commonly used TSQL queries for DBAs, how to use them effectively, and the benefits they offer. Whether you're a beginner or…
Read FullIn this article, we'll explore some of the most commonly used TSQL queries for DBAs, how to use them effectively, and the benefits they offer. Whether you're a beginner or…
Read FullSpace Management TSQL Commands 1)sp_spaceused2)dbcc sqlperf(logspace)3)xp_fixeddrives Information TSQL Commands 1) sp_helpdb2) select db_id('DBName')3) select db_name(DBID)4) select * from sys.dm_exec_sessions, dm_exec_connections5) select * from sys.databases6) select * from sys.database_files Monitoring TSQL…
Read Full