Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Search Rss

Search for any content tagged search

   Items 1 to 16 of 16   
 

Learning to Search

Today Steve Jones notes that the ability to search if invaluable as the amount of information, or even objects, we deal with grows.  Read more...
By Steve Jones 2016/07/27 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 59 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 2016/02/12 (first published: 2014/04/07) | Source: SQLServerCentral.com | Category: sql like search
Rating: |  Discuss |   Briefcase | 38,396 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 2016/02/12 (first published: 2014/04/07) | Source: SQLServerCentral.com | Category: sql like search
Rating: |  Discuss |   Briefcase | 38,396 reads

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 | 8,244 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 2016/02/12 (first published: 2014/04/07) | Source: SQLServerCentral.com | Category: sql like search
Rating: |  Discuss |   Briefcase | 38,396 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 | 24,323 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,898 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 | 24,323 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,705 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,705 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,298 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,488 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,705 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,115 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,600 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,463 reads
   Items 1 to 16 of 16