This article describes a utility that allows you to inspect cached plans and extract information that can be useful in improving the performance of your SQL.  Read more...

This script will help you search all tables for a specific set of text.  Read more...

Recently Ben Kubicek created a script that would allow him to copy his production db to a test instance and correct the production specific SQL code in stored procedures and views.   Read more...

This script allows a user to search every field in a database for a specified value - handy when knowing the data but not the schema.  Read more...

This procedure searches for your criteria not only in code, but also in objectnames  Read more...

An easy method to search inherited SP codes for a particular text  Read more...

Searches for tables who's names contain the search string. Gives Aggregate Size, Rows, Index, and Column information as well.  Read more...

Searches for columns with names containing @Colname that belong to tables with names containing @TableName or schemas with names containing @SchemaName. Gives size and rowcount for tables.  Read more...

Searches for foreign key constraints that don't have fully matching indexes. The best partial matching indexes are outputted with MatchCounts and column comparisons.  Read more...

Searches for tables who's names contain the search string. Gives Size and Rows information as well.  Read more...

Searches for actual and potential foreign key columns for a given primary key reference.  Read more...

Searches precompiled procedures for the provided search string, optionally limiting to names matching a 2nd search string.  Read more...

Searches for objects (including CLR) who's names contain the search string. outputs IDs, names, and types of the object and its parent.  Read more...

Lists Schema/Object of tables that are missing a Primary Key or Clustered Index, along with aggregate data for size, rows, indexes, and columns.  Read more...

You can't let a little thing like not knowing a database's structure keep you from your work. Without identifying tables and columns, you can still find specific values and columns.   Read more...

This article describes a utility that allows you to inspect cached plans and extract information that can be useful in improving the performance of your SQL.  Read more...

Search any database (or a combination databases, including all) for a specific string found in column names, object names, and /or object definitions.  Read more...

Search any database (or a combination databases, including all) for a specific string found in column names, object names, and /or object definitions.  Read more...

i have recently had the need to search the every database on the server for a particular string. i came up with this... it has lots of room for improvement but it works  Read more...

Lists Schema/Object of tables that are missing a Primary Key or Clustered Index, along with aggregate data for size, rows, indexes, and columns.  Read more...