DBA in day to day activities Archives • Our Tech Ideas

Some TSQL queries used by SQL DBA in day to day activities

by OTI September 17, 2019

Database log file full. How to find log file used and free space?

--Run below script to any database, you will get result for all the database
DBCC SQLPERF(LOGSPACE)

1 2	--Run below script to any database, you will get result for all the database DBCC SQLPERF(LOGSPACE)

Low disk space. How to find…