Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Authors
About us
Contact us
Newsletters
Write for us
Daily SQL Articles by email:
Sign up
Articles with tag
Search
Search for
any
content tagged
search
Items 1 to 18 of 18
Fuzzy Search
Finally a fuzzy search that finds all sorts of misspellings and missing parts.
Read more...
By
William Talada
2017/08/03
|
Source:
SQLServerCentral.com
|
Category:
fuzzy
Rating:
|
Discuss
|
Briefcase
|
2,153 reads
Doing Fuzzy Searches in SQL Server
A series of arguments with developers who insist that fuzzy searches or spell-checking be done within the application rather then a relational database inspired Phil Factor to show how it is done. When the database must find relevant material from search terms entered by users, the database must learn to expect, and deal with, both expected and unexpected.
Read more...
By
Additional Articles
2017/04/27
|
Source:
SimpleTalk
|
Category:
sql
Rating:
Rate this
|
Briefcase
|
7,231 reads
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
|
83 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,771 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,771 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,746 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,771 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,611 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,917 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,611 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,748 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,748 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,301 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,637 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,748 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,125 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,817 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,612 reads
Items 1 to 18 of 18
Copyright © 2002-2019 Redgate. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.