SQLServerCentral.com Content tagged Search

A google like search

Thu, 02 Feb 2012 07:00:00 UT

A conceptual proof for a google like search procedure

Find occurence of any value in database!

Mon, 09 Jan 2012 07:00:00 UT

Search entire database for occurrence of any text!

Search for a String in all Stored Procedures and beyond?

Thu, 20 Oct 2011 06:00:00 UT

Search for String Occurence with this script in your stored procedures.

Get smart with SQL Backup Pro
Powerful centralised management, encryption and more.
SQL Backup Pro was the smartest kid at school.
Discover why.

Object Search

Wed, 19 Oct 2011 06:00:00 UT

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

Search for a text in all databases

Wed, 02 Mar 2011 07:00:00 UT

This procedure searches for a specified text in all (or one selected) databases in all (or selected) tables.

Get Smart with SQL Backup Pro
Powerful centralised management, encryption and more.
SQL Backup Pro was the smartest kid at school
Discover why.

Searching through SPs, Tables, Views

Wed, 09 Feb 2011 07:00:00 UT

Find quickly all stored procedures, tables and views that are somehow related to the search term.

Search all columns in every table for a value

Tue, 09 Nov 2010 07:00:00 UT

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.

Find a string in database objects

Mon, 21 Jun 2010 06:00:00 UT

A very simple way to find a string in database objects and see where it is located in object definition.

Object Search

Wed, 19 Oct 2011 06:00:00 UT

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

Get Performance Tips Directly From SQL Server

Fri, 02 Apr 2010 06:00:00 UT

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.

Search all tables for text

Mon, 15 Feb 2010 07:00:00 UT

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

A Search and Replace Script when Moving Objects from Prod to Test

Wed, 03 Feb 2010 07:00:00 UT

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.

Search all columns in every table for a value

Tue, 09 Nov 2010 07:00:00 UT

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.

Search in your T-SQL objects

Mon, 16 Nov 2009 07:00:00 UT

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

Search a particular text string in all SPs

Fri, 23 Oct 2009 06:00:00 UT

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

The Ultimate Table Searcher Mk2

Tue, 20 Oct 2009 06:00:00 UT

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

The Ultimate Column Searcher

Fri, 16 Oct 2009 06:00:00 UT

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.

The Ultimate Index-Less Foreign-Key Finder

Thu, 15 Oct 2009 06:00:00 UT

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

The Ultimate Table Searcher

Wed, 14 Oct 2009 06:00:00 UT

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

The Ultimate Foreign Key Researcher

Mon, 12 Oct 2009 06:00:00 UT

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

The Ultimate Precompiled Procedure Searcher

Thu, 08 Oct 2009 06:00:00 UT

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

The Ultimate Object Searcher

Tue, 06 Oct 2009 06:00:00 UT

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

The Ultimate PK-Less / CLIDX-Less Table Finder

Fri, 02 Oct 2009 06:00:00 UT

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

Searching Unidentified Tables and Columns for Specific Content

Wed, 29 Jul 2009 06:00:00 UT

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.

Get Performance Tips Directly From SQL Server

Fri, 02 Apr 2010 06:00:00 UT

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.

Get smart with SQL Backup Pro
Powerful centralised management, encryption and more.
SQL Backup Pro was the smartest kid at school.
Discover why.

Object Search

Wed, 19 Oct 2011 06:00:00 UT

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

Object Search

Wed, 19 Oct 2011 06:00:00 UT

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

search every database on server from a single sp

Fri, 19 Dec 2008 07:00:00 UT

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

Get Smart with SQL Backup Pro
Powerful centralised management, encryption and more.
SQL Backup Pro was the smartest kid at school
Discover why.

The Ultimate PK-Less / CLIDX-Less Table Finder

Fri, 02 Oct 2009 06:00:00 UT

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

Finding Values With Numerous Columns

Tue, 02 Dec 2008 07:00:00 UT

Techniques for finding values in a denormalized table.