Get queries with same plan
Analyze plan cache for multiple use of plan by same query. Script is part of execution plan analysis series. You can use it to find how many plans generated by...
Shrink log for all user databases
Bulk shrink of transaction log for all databases. This script is handy when your transaction logs grown big on several databases. You want to shrink all log files quickly so...
Data files latency
Examine performance of particular data files for all databases. Useful when troubleshooting performance of your SQL Server. Latency is one of the main performance counters measuring IO performance for SQL...
Generate persons test data
Quickly generate some persons data using popular AdventureWorks database sample. If you need to quickly test some functionality you would probably require some data for your tables. This script is...
Maintenance as part of your life
Every website or application requires some maintenance from time to time. As common user you can be unaware of such requirements and it can be painful to take care of...
Get cached execution plans
Look into your cache and see what execution plans live there. You can quickly identify what SQL Server stored in plan cache and see how many time was this plan...
Add database role(s) in multiple databases
Add login to same database roles in multiple databases can be time consuming. You find this useful when you need to add some login to instance. Especially when application using...
Jobs overview
Quick overview of all SQL Agent jobs. You can check how many SQL Agent jobs you have created and their basic information. Returns jobs schedule information and status. Something similar...
Identify missing backups
Quick check if all your databases are backed up. It is important for every DBA that databases you are responsible of are properly backed up. Use this script to identify...