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 12 of 12   
 

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 | 14,573 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 | 22,968 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,796 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 | 22,968 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,328 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,328 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,285 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,385 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,328 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,041 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,399 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,366 reads
   Items 1 to 12 of 12