Break database consistency
This is risky! Be aware of doing this on some production database. This script is published for training purposes only. Use it with caution, this will definitely break your database,...
TempDB configuration check
TempDB is heavily used database in every instance, time to check it. As every DBA know TempDB database is shared for all sessions within DB engine. This makes its performance...
Datafile auto-growth events
Looks for auto-growth events in default SQL Server trace. You can find this information in SSMS built-in database standard report Disk usage under charts. This part of report is available...
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...