SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 The Yak Corral
 Twit List
 New Topic  Reply to Topic
 Printer Friendly
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 88

spirit1
Cybernetic Yak Master

Slovenia
11750 Posts

Posted - 07/22/2008 :  08:34:01  Show Profile  Visit spirit1's Homepage  Reply with Quote
nope not the same ip.

_______________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.0 out!
Go to Top of Page

tosscrosby
Aged Yak Warrior

USA
676 Posts

Posted - 07/22/2008 :  08:43:47  Show Profile  Reply with Quote
Well, hopefully those fine folks aren't out there procreating.....

Terry
Go to Top of Page

elancaster
A very urgent SQL Yakette

United Kingdom
1208 Posts

Posted - 07/22/2008 :  11:11:02  Show Profile  Reply with Quote
lol
"er... my friend has this problem..."
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=107130

quote:
Originally posted by elancaster

well... i haven't come looking for the twit list in a while. i must be in a bad mood today
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=106774

Em



Em
Go to Top of Page

elancaster
A very urgent SQL Yakette

United Kingdom
1208 Posts

Posted - 07/24/2008 :  10:47:59  Show Profile  Reply with Quote
this guy is really start to get on my nerves...
http://www.sqlteam.com/forums/pop_profile.asp?mode=display&id=39129

Em
Go to Top of Page

spirit1
Cybernetic Yak Master

Slovenia
11750 Posts

Posted - 07/24/2008 :  10:53:47  Show Profile  Visit spirit1's Homepage  Reply with Quote
so don't answer him
on this forum anyone has a right to be a twit.


_______________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.0 out!

Edited by - spirit1 on 07/24/2008 10:53:57
Go to Top of Page

tosscrosby
Aged Yak Warrior

USA
676 Posts

Posted - 07/24/2008 :  11:14:13  Show Profile  Reply with Quote
quote:
Originally posted by elancaster

this guy is really start to get on my nerves...
http://www.sqlteam.com/forums/pop_profile.asp?mode=display&id=39129

Em



Mine too, but I didn't want to call him out yet. I was thinking maybe it was me as I'm having a "not so good" morning and am just a bit irritable so I was trying to "play nice". Obviously, it's not me!

Terry
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30212 Posts

Posted - 08/10/2008 :  14:32:14  Show Profile  Visit SwePeso's Homepage  Reply with Quote
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=108431



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30212 Posts

Posted - 08/11/2008 :  11:54:50  Show Profile  Visit SwePeso's Homepage  Reply with Quote
I don't want anyone to remedy my IDENTITY problems!
But please give other suggestion. Suggestion MUST involve my beloved CURSOR.
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=108471



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 08/28/2008 :  22:02:55  Show Profile  Reply with Quote
I think this guy is just turning into a parody of himself.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=109701
"i want to combine the 2 scripts with an if statement. How can i do it? If you are not familir with this task. do not reply."


CODO ERGO SUM
Go to Top of Page

jezemine
Flowing Fount of Yak Knowledge

USA
2886 Posts

Posted - 08/31/2008 :  11:21:31  Show Profile  Visit jezemine's Homepage  Reply with Quote
who is the bigger twit? Lockheed Martin, or the US govt that paid 500 million for it?

http://online.wsj.com/article/SB121937117186362585.html


elsasoft.org
Go to Top of Page

blindman
Flowing Fount of Yak Knowledge

USA
2365 Posts

Posted - 09/02/2008 :  12:43:38  Show Profile  Reply with Quote
quote:
When tested, the new system failed to find matches for terrorist-suspect names that were spelled slightly different from the name entered into the system, a common challenge when translating names from Arabic to English. It also could not perform basic searches of multiple words connected with terms such as "and" and "or."


Makes me wonder if they are using SOUNDEX.

Should I offer to sell them my fuzzy-search algorithm for a paltry million dollars?

Boycotted Beijing Olympics 2008

Edited by - blindman on 09/02/2008 12:44:10
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 09/02/2008 :  18:10:24  Show Profile  Reply with Quote
Did they consider the possibility that someone might just use a fake name?

I guess they're too busy making sure no one tries to carry more than 2 oz. of mouthwash onto a plane.








CODO ERGO SUM
Go to Top of Page

jezemine
Flowing Fount of Yak Knowledge

USA
2886 Posts

Posted - 09/03/2008 :  00:53:36  Show Profile  Visit jezemine's Homepage  Reply with Quote
too bad the mouthwash patrols aren't using this db.

then you wouldn't be able to take '2 oz.' but all these would get through:

'2 ounces'
'two ounces'
'two oz.'


elsasoft.org
Go to Top of Page

Stoad strehngthend
Yak Posting Veteran

54 Posts

Posted - 09/04/2008 :  12:32:05  Show Profile  Visit Stoad strehngthend's Homepage  Reply with Quote
>blindman:
>my fuzzy-search algorithm

Any link to read about it (your implemention)? If you were not kidding on this

Go to Top of Page

blindman
Flowing Fount of Yak Knowledge

USA
2365 Posts

Posted - 09/04/2008 :  15:00:51  Show Profile  Reply with Quote
Sorry. I've posted this before, but here it is:
http://sqlblindman.googlepages.com/fuzzysearchalgorithm

...but if I find you YOU sold it to them for a million dollars, I'll come looking for you!

Boycotted Beijing Olympics 2008

Edited by - blindman on 09/04/2008 15:01:45
Go to Top of Page

Stoad strehngthend
Yak Posting Veteran

54 Posts

Posted - 09/04/2008 :  15:13:51  Show Profile  Visit Stoad strehngthend's Homepage  Reply with Quote
thanks :) I'll study it
==========================
btw a bit related to our subj: http://www.spoj.pl/problems/PRHYME/
I tried it but timelimited. True I did it in Python nonetheless..
Not so easy all it; and I'm very unwilling to rewrite it in C++
Go to Top of Page

Stoad strehngthend
Yak Posting Veteran

54 Posts

Posted - 09/04/2008 :  17:04:03  Show Profile  Visit Stoad strehngthend's Homepage  Reply with Quote

print dbo.CompareText('Alan Smith', 'Alan Smith')
print dbo.CompareText('Alan Smith', 'Smith, Alan J.')
print dbo.CompareText('Alan Smith', 'Alan J. Smith')
print dbo.CompareText('Alan Smith', 'Alan Smith, jr')

100
72
85
81  ----<< to my taste it should be 100
    ----<< ok after all it's fuzzy :)
    ----<< it's silently implied that "Alan Smith" has nothing more in it
    ----<< it's not a prefix; it's a whole name of an orphan that cannot be "juniour"

Go to Top of Page

DavidChel
Constraint Violating Yak Guru

USA
474 Posts

Posted - 09/05/2008 :  08:46:07  Show Profile  Reply with Quote
I hereby nominate myself.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=110068

Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30212 Posts

Posted - 09/05/2008 :  09:09:45  Show Profile  Visit SwePeso's Homepage  Reply with Quote
Someone has to be first
I am just lucky I haven't made any mockup yet.


E 12°55'05.63"
N 56°04'39.26"

Edited by - SwePeso on 09/05/2008 09:11:53
Go to Top of Page

blindman
Flowing Fount of Yak Knowledge

USA
2365 Posts

Posted - 09/05/2008 :  10:33:41  Show Profile  Reply with Quote
Stoad, first of all the function is CompareTEXT, not CompareNAME. As you can see from the code it does not parse the string into name components. It treats it as a single text string, which also allows it to be used for comparing addresses and other strings (such as foreign names that do not follow Western three-part name formats).

Second:
quote:
Originally posted by Stoad strehngthend


print dbo.CompareText('Alan Smith', 'Alan Smith, jr')
81  ----<< to my taste it should be 100


...then your taste would be wrong. When searching for "Alan Smith" you cannot match it 100% against "Alan Smith, jr". There could be an "Alan Smith, Sr" in the database, or even simply another "Alan Smith".

Boycotted Beijing Olympics 2008

Edited by - blindman on 09/05/2008 10:35:11
Go to Top of Page
Page: of 88 Previous Topic Topic Next Topic  
Previous Page | Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.22 seconds. Powered By: Snitz Forums 2000