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...
Posts related to SQL Server topics, divided to more subcategories by topic focus
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...
Search for value
You want to find some value within whole database, in all tables and columns? You can use this script for searching of value in your database, I found it when...
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...
Check actual replica
You want to execute script against database only if actual database is primary replica? Sometimes you need to continue execution of batch only when actual database is primary replica on...
Suspend & resume data movement
Sometimes you need to reinitialize data movement in Availability Group. You can do that by right clicking Availability Database in SSMS then clicking "Suspend Data Movement" then clicking "Resume Data...
Connectivity issues
Return actual state of local replica connectivity to other replicas in Availability Group. Can be useful for fast check or in some automation or inventory solution....