Click here to Skip to main content
12,750,710 members (38,705 online)
   

Database

 
GeneralRe: oltp vs olap Pin
Mycroft Holmes2-Dec-12 14:28
memberMycroft Holmes2-Dec-12 14:28 
GeneralRe: oltp vs olap Pin
a.fatemeh2-Dec-12 14:41
membera.fatemeh2-Dec-12 14:41 
GeneralSQL instance name when using network group Pin
Aamir Saleem2-Dec-12 11:32
memberAamir Saleem2-Dec-12 11:32 
GeneralRe: SQL instance name when using network group Pin
Mycroft Holmes2-Dec-12 12:43
memberMycroft Holmes2-Dec-12 12:43 
QuestionACL vs SQL for fuzzy matching Pin
Ben Dessau29-Nov-12 5:15
memberBen Dessau29-Nov-12 5:15 
AnswerRe: ACL vs SQL for fuzzy matching Pin
Pete O'Hanlon29-Nov-12 6:07
protectorPete O'Hanlon29-Nov-12 6:07 
GeneralRe: ACL vs SQL for fuzzy matching Pin
Ben Dessau29-Nov-12 7:43
memberBen Dessau29-Nov-12 7:43 
GeneralRe: ACL vs SQL for fuzzy matching Pin
Pete O'Hanlon29-Nov-12 7:50
protectorPete O'Hanlon29-Nov-12 7:50 
At the most basic, you're talking about Soundex matching, which isn't great. You might want to consider Full Text Indexing, which will return misspelled items if they are close enough. Of course, you can always implement your own fuzzy logic inside SQL Server, using CLR functions.

*pre-emptive celebratory nipple tassle jiggle* - Sean Ewington

"Mind bleach! Send me mind bleach!" - Nagy Vilmos


CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier

QuestionSQL Query Pin
berba29-Nov-12 3:22
memberberba29-Nov-12 3:22 
AnswerRe: SQL Query Pin
Richard Deeming29-Nov-12 3:50
memberRichard Deeming29-Nov-12 3:50 
GeneralRe: SQL Query Pin
berba2-Dec-12 19:30
memberberba2-Dec-12 19:30 
QuestionSQL Server windows authentication Pin
zead29-Nov-12 0:49
memberzead29-Nov-12 0:49 
AnswerRe: SQL Server windows authentication Pin
Garth J Lancaster29-Nov-12 0:59
memberGarth J Lancaster29-Nov-12 0:59 
AnswerRe: SQL Server windows authentication Pin
jschell29-Nov-12 9:09
memberjschell29-Nov-12 9:09 
GeneralRe: SQL Server windows authentication Pin
Chris Meech30-Nov-12 4:45
memberChris Meech30-Nov-12 4:45 
QuestionNeed help with a tricky MS SQL Query Pin
muya mwansa27-Nov-12 7:46
membermuya mwansa27-Nov-12 7:46 
AnswerRe: Need help with a tricky MS SQL Query Pin
Eddy Vluggen27-Nov-12 14:31
memberEddy Vluggen27-Nov-12 14:31 
GeneralRe: Need help with a tricky MS SQL Query Pin
jschell28-Nov-12 9:43
memberjschell28-Nov-12 9:43 
AnswerRe: Need help with a tricky MS SQL Query Pin
Deepak Kumar1128-Nov-12 2:03
memberDeepak Kumar1128-Nov-12 2:03 
QuestionBest Approach For Designing Database Pin
AmbiguousName27-Nov-12 4:59
memberAmbiguousName27-Nov-12 4:59 
AnswerRe: Best Approach For Designing Database Pin
jschell27-Nov-12 14:13
memberjschell27-Nov-12 14:13 
AnswerRe: Best Approach For Designing Database Pin
Mycroft Holmes27-Nov-12 14:14
memberMycroft Holmes27-Nov-12 14:14 
AnswerRe: Best Approach For Designing Database Pin
Eddy Vluggen27-Nov-12 14:23
memberEddy Vluggen27-Nov-12 14:23 
AnswerRe: Best Approach For Designing Database Pin
Krishna Kumar Soni3-Dec-12 2:04
memberKrishna Kumar Soni3-Dec-12 2:04 
QuestionEXEC sp_helptext Pin
jojoba201126-Nov-12 23:43
memberjojoba201126-Nov-12 23:43 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web02 | 2.8.170215.1 | Last Updated 20 Feb 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid