<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Content with tags
T-SQL
,
like
Items 1 to 4 of 4
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,550 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,550 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 Seaman
2010/01/13
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
8,932 reads
not like?
Read more...
By
VM-723206
2009/03/23
|
Category:
like
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
4,620 reads
Items 1 to 4 of 4
Tags
computed column
(1)
performance tuning
(1)
reverse
(1)
string manipulation
(1)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
