<a href="//g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="//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="//g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="//g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Articles with tag
Search
Search for
any
content tagged
search
Items 1 to 14 of 14
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
2015/01/16 (first published: 2014/04/07)
|
Source:
SQLServerCentral.com
|
Category:
sql like search
Rating:
|
Discuss
|
Briefcase
|
29,977 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
|
7,765 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
2015/01/16 (first published: 2014/04/07)
|
Source:
SQLServerCentral.com
|
Category:
sql like search
Rating:
|
Discuss
|
Briefcase
|
29,977 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,726 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,851 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,726 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,557 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,557 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,296 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,425 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,557 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,081 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,448 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,399 reads
Items 1 to 14 of 14
Copyright © 2002-2015 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
