Set multiple database mode
Generate script for changing mode for multiple databases. In given script I'm setting databases to Single-user and back to normal stace. Then changing state to Read-Only and back to Read-Write,...
Update statistics for all databases
Easily update statistics with one line function. I know that you are maintaining statistics by some maintenance jobs scheduled to run on regular basis. You can use builtin Maintenance plans...
Index usage
Check how are your indexes doing in the database. This script is very useful when you are doing some performance optimizations by creating new indexes. Or trying to find some...
Index list
Get information about all existing indexes in given database. This script can be handful when you want to check all indexes with their create scripts and some of useful information...
Collect DBCC CHECKDB results
Get more more handful information about corrupted database. Best practice to check database consistency and integrity on regular basis to prevent more data damage will help you to find out...
Disk drives size
Returns information about space on disk drives used by databases in instance. This c an be handful in automation for example before creating or restoring new database. Also can be...
Size of each database
Returns size of all databases all database files with its location and state....
Size summary
Returns summary of all data within SQL Server instance grouped by type. Tempdb database size excluded. Script can be handy during analyze of instance, disk drives sizing, memory sizing etc....
Last schema changes
Shows information about schema changes done in databases by DDL operations. This is quick listing for all databases containing information about last schema changes done in every database.
TIP: If you...
Batch database drop
You need to drop more databases quickly. If you want to drop some database you can use SSMS GUI or T-SQL to drop single database, but if you need to...