SQLServerCentral.com Articles tagged Search

Search for a Value Throughout Your Database

Thu, 14 Mar 2013 06:00:00 UT

Learn how to search for a value throughout all database tables.

Fuzzy-String Search: Find misspelled information with T-SQL

Tue, 18 Sep 2012 06:00:00 UT

An optimized Damerau-Levenshtein Distance (DLD) algorithm for "fuzzy" string matching in Transact-SQL 2000-2008

Get Performance Tips Directly From SQL Server

Fri, 22 Jun 2012 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 Performance Tips Directly From SQL Server

Fri, 22 Jun 2012 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.

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.

12 essential tools for database professionals
The SQL Developer Bundle contains 12 tools designed with the SQL Server developer and DBA in mind. Try it now.

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, 22 Jun 2012 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.

Finding Values With Numerous Columns

Tue, 02 Dec 2008 07:00:00 UT

Techniques for finding values in a denormalized table.

Dynamic Search Conditions

Tue, 25 Mar 2008 06:00:00 UT

ow to write a stored procedure that permits users to select among many search conditions, using both dynamic and static SQL.

Employ Metadata to Enhance Search Filters

Thu, 13 Mar 2008 06:00:00 UT

Discover how to use metadata for pooling information already resident in an application to create a flexible search interface that reduces complexity and increases users' productivity.