Useful DBA Scripts
- SQL Script: – How to find the last access date of a database
- T-SQL script to find the growth size of database files
- Script to find all the running queries/jobs on the Database Server
- SQL Script to find the last executed commands on the SQl Server
- T-SQL script to find the highly populated tables in database
- SQL Script to find the databases size
- SQL Script to find the tables created from a given date
- SQL Script to search stored procedures containing a given text
- SQL Script to find the list of all the jobs failed yesterday
- Script to find the Fragmentation of indexes