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

Content with tag like Rss

   Items 1 to 9 of 9   
 

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 | 15,118 reads

LIKE and NULLs

By G. C. 2014/02/13 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,366 reads

wildcards

By Steve Jones 2013/09/11 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,364 reads

T-SQL Like

By Kathiravan P 2013/07/03 | Category: like
Rating: (not yet rated) |  Discuss |   Briefcase | 3,413 reads

Key Word Searches

This article from Todd Fifield shows a Way to avoid the dreaded LIKE operator in your queries and dramatically speed up keyword searches.  Read more...
By Todd Fifield 2012/09/07 (first published: 2011/02/28) | Source: SQLServerCentral.com | Category: string manipulation
Rating: |  Discuss |   Briefcase | 34,651 reads

Key Word Searches

This article from Todd Fifield shows a Way to avoid the dreaded LIKE operator in your queries and dramatically speed up keyword searches.  Read more...
By Todd Fifield 2012/09/07 (first published: 2011/02/28) | Source: SQLServerCentral.com | Category: string manipulation
Rating: |  Discuss |   Briefcase | 34,651 reads

Optimising “Ends With” searches with REVERSE

A simple way to improve performance for queries that use the LIKE operator. Ben Seaman shows how to deal with searches that look at the end of a piece of text  Read more...
By Ben Whitman 2010/01/13 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 8,995 reads

Search for a Table in all databases

This Script can be used for searching a Table in SQL server 2005  Read more...
By Sandesh Segu 2009/08/04 | Source: SQLServerCentral.com | Category: table search
Rating: |  Discuss |   Briefcase | 1,036 reads

not like?

By VM-723206 2009/03/23 | Category: like
Rating: (not yet rated) |  Discuss |   Briefcase | 4,660 reads
   Items 1 to 9 of 9   
 
Tags
t-sql (6)    
computed columns (1)    
performance tuning (1)    
reverse (1)    
search (1)    
sp_msforeachdb (1)    
sql like search (1)    
sql server 2005 (1)    
string manipulation (1)    
table search (1)