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...

This script will search all registered servers, databases, tables, columns, stored procedures for text.  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...

Techniques for finding values in a denormalized table.  Read more...

Find in a flexible way different type of objects on databases.  Read more...

This utility will find strings in procedures, functions, views, and even check constraints.  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...

Techniques for finding values in a denormalized table.  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...