Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Search Rss

Search for any content tagged search

   Items 1 to 13 of 13   
 

Searching for Strings in SQL Server Databases

Sometimes, you just want to do a search in a SQL Server database as if you were using a search engine like Google. Besides the obvious Full-Text search, Phil Factor describes some of the techniques for finding that pesky data that resists the normal SELECT blandishments.  Read more...
By Additional Articles 2014/05/01 | Source: SimpleTalk | Category: search
Rating:  Rate this |   Briefcase | 7,714 reads

Improving Performance for Some LIKE “%string%” Searches (SQL Spackle)

If you've ever wondered if you can do better than an INDEX SCAN when you do a LIKE "%string%" search, read on...  Read more...
By Dwain Camps 2014/04/07 | Source: SQLServerCentral.com | Category: sql like search
Rating: |  Discuss |   Briefcase | 16,722 reads

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

An optimized Damerau-Levenshtein Distance (DLD) algorithm for "fuzzy" string matching in Transact-SQL 2000-2008  Read more...
By Thomas Keller 2014/01/10 (first published: 2012/09/18) | Source: SQLServerCentral.com | Category: fuzzy match
Rating: |  Discuss |   Briefcase | 23,641 reads

Search for a Value Throughout Your Database

Learn how to search for a value throughout all database tables.  Read more...
By Gaurav Goel 2013/03/14 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 6,846 reads

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

An optimized Damerau-Levenshtein Distance (DLD) algorithm for "fuzzy" string matching in Transact-SQL 2000-2008  Read more...
By Thomas Keller 2014/01/10 (first published: 2012/09/18) | Source: SQLServerCentral.com | Category: fuzzy match
Rating: |  Discuss |   Briefcase | 23,641 reads

Get Performance Tips Directly From SQL Server

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...
By Ian Stirk 2012/06/22 (first published: 2009/06/11) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 46,515 reads

Get Performance Tips Directly From SQL Server

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...
By Ian Stirk 2012/06/22 (first published: 2009/06/11) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 46,515 reads

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

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...
By Ben Kubicek 2010/02/03 | Source: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 7,293 reads

Searching Unidentified Tables and Columns for Specific Content

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...
By Additional Articles 2009/07/29 | Source: DevX | Category: search
Rating: (not yet rated)  Rate this |   Briefcase | 2,417 reads

Get Performance Tips Directly From SQL Server

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...
By Ian Stirk 2012/06/22 (first published: 2009/06/11) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 46,515 reads

Finding Values With Numerous Columns

Techniques for finding values in a denormalized table.  Read more...
By Timothy A Wiseman 2008/12/02 | Source: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 8,071 reads

Dynamic Search Conditions

ow to write a stored procedure that permits users to select among many search conditions, using both dynamic and static SQL.  Read more...
By Additional Articles 2008/03/25 | Source: Erland Sommarskog's SQL Page | Category: t-sql
Rating:  Rate this |   Briefcase | 3,433 reads

Employ Metadata to Enhance Search Filters

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.  Read more...
By Additional Articles 2008/03/13 | Source: DevX | Category: search
Rating: (not yet rated)  Rate this |   Briefcase | 2,387 reads
   Items 1 to 13 of 13