This utility will locate a column across a subset or all databases across a server. Can be configured to run across versions, and can search tables, views or both.  Read more...

Extract data from XML file from dynamic tag. in this below e.g we can add / remove Escalations tag from xml file. and depends on that result will display.  Read more...

Reports table columns that are not foreign keys but that perhaps should be.  Read more...

This script quickly returns Server Name, Cluster Node, Default Drive Letter for MSDB database, IP address and port  Read more...

Index Maintenance procedure with HTML Reporting capabilities. Please refer to attached script for detailed information.  Read more...

This script lists all of the SQL logins with their password policy  Read more...

This script will list the operators that have jobs that are configured to notify them with alerts.  Read more...

list each user has the right to do  Read more...

Display multiple rows values as single row value in different rows (No Cursor).  Read more...

It shows you the compression state of all indexes/tables of a database.  Read more...

It compresses all the tables/indexes in a database, a specific one or all the objects inside a database schema.  Read more...

Identifies potential page allocation contention in TEMPDB.  Read more...

Lists the TempDB usage per each active session.   Read more...

Report unusual conditions that may be filling up your transaction log.  Read more...

Calculates the signal and resource waits as a percentage of overall wait time.  Read more...

Identifies potentially missing indexes.  Read more...

Finds tables and indexes that do not show up in the usage statistics.  Read more...

Clears the wait statistics so that the results of the 'Signal and Resource Waits' scripts are more relevant  Read more...