Garbage in, Garbage out

Here are a few gems I just found in out JobTitle table, which stores contact
job titles in our database. If we have a job title, it's because it came in
a bulk-insert data file from a client.
The best
the big dawg
the boss
the man
The Master Himself
THE ONLY PERSON IN IT DEPARTMENT
The Simpsons
The Veritable Bugeater
ROFL!
Peace & happy computing,
Mike Labosh, MCSD
"When you kill a man, you're a murderer.
Kill many, and you're a conqueror.
Kill them all and you're a god." -- Dave Mustane"Mike Labosh" <mlabosh@.hotmail.com> wrote in message
news:emwFdG2zFHA.904@.tk2msftngp13.phx.gbl...
> The Veritable Bugeater
I'd like to hear the story behind this one.
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--|||"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:e8znzZ2zFHA.664@.tk2msftngp13.phx.gbl...
> "Mike Labosh" <mlabosh@.hotmail.com> wrote in message
> news:emwFdG2zFHA.904@.tk2msftngp13.phx.gbl...
>
> I'd like to hear the story behind this one.
>
> --
> Adam Machanic
> SQL Server MVP
> http://www.datamanipulation.net
> --
>
>
Probably not the real story, but anyway:
http://mynptv.org/sportsFeat/pionee..._lessplan1.html|||What a nightmare (it annoys me when I find data like this in a database.
Why the heck even have a column if you allow stuff like this, obviously more
annoyed by the original people to enter the data. I know if you get the
data there is probably an expectation that it is right (which is obviously
false :). I wonder if any ETL product would catch this sort of thing and
exception it out before it was entered into the database?
----
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP
"Arguments are to be avoided: they are always vulgar and often convincing."
(Oscar Wilde)
"Mike Labosh" <mlabosh@.hotmail.com> wrote in message
news:emwFdG2zFHA.904@.tk2msftngp13.phx.gbl...
> Here are a few gems I just found in out JobTitle table, which stores
> contact job titles in our database. If we have a job title, it's because
> it came in a bulk-insert data file from a client.
> The best
> the big dawg
> the boss
> the man
> The Master Himself
> THE ONLY PERSON IN IT DEPARTMENT
> The Simpsons
> The Veritable Bugeater
> ROFL!
> --
> Peace & happy computing,
> Mike Labosh, MCSD
> "When you kill a man, you're a murderer.
> Kill many, and you're a conqueror.
> Kill them all and you're a god." -- Dave Mustane
>|||> What a nightmare (it annoys me when I find data like this in a database.
> Why the heck even have a column if you allow stuff like this, obviously
> more annoyed by the original people to enter the data. I know if you get
> the data there is probably an expectation that it is right (which is
> obviously false :). I wonder if any ETL product would catch this sort of
> thing and exception it out before it was entered into the database?
heh.
If you worked here, you would hurt someone.
I could list snips from all the databases in the company that are all
similarly stupid. They don't want any automation, either: "Don't program
anything, we don't have the time. Just hurry up and copy/paste these 700
values into this Word template."
A homeless dude off the street could do this work. Why hire a guy that can
write code in 6 languages?!?
[bonking head on desk]
Anybody need a MCSD MCT? I'll be there in the morning!
Peace & happy computing,
Mike Labosh, MCSD
"When you kill a man, you're a murderer.
Kill many, and you're a conqueror.
Kill them all and you're a god." -- Dave Mustane|||Mike, I'll follow you :-)

Fulltext query not seeming to use "and"

I have the following:
SELECT jobTitle from position where FreeText(jobDescription,'sales and
ccna') order by JobTitle DESC
This gives me 11 hits
If change change the FreeText clause to:
FreeText(jobDescription,'sales')
I get the same 11 hits.
But if I change it to:
FreeText(jobDescription,'ccna')
I get no hits.
I would have thought 'sales and ccna' would also have given me 0 hits.
What am I missing?
Thanks,
Tom
You should use a boolean AND for this with Contains to get what you are
looking for.
select * from Contains(*,'"sales" and "ccna"')
FreeText will ignore the and unless it is removed from the noise word list,
in which case it will search on it. FreeText is a fuzzy search and not
exact. So it will rank rows which contain sales and ccna higher than rows
which contain only ccan or only sales.
..
"tshad" <tscheiderich@.ftsolutions.com> wrote in message
news:upqxO%23aKFHA.1308@.TK2MSFTNGP15.phx.gbl...
>I have the following:
> SELECT jobTitle from position where FreeText(jobDescription,'sales
> and ccna') order by JobTitle DESC
> This gives me 11 hits
> If change change the FreeText clause to:
> FreeText(jobDescription,'sales')
> I get the same 11 hits.
> But if I change it to:
> FreeText(jobDescription,'ccna')
> I get no hits.
> I would have thought 'sales and ccna' would also have given me 0 hits.
> What am I missing?
> Thanks,
> Tom
>
|||"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OL0z5HbKFHA.436@.TK2MSFTNGP09.phx.gbl...
> You should use a boolean AND for this with Contains to get what you are
> looking for.
> select * from Contains(*,'"sales" and "ccna"')
> FreeText will ignore the and unless it is removed from the noise word
> list, in which case it will search on it. FreeText is a fuzzy search and
> not exact. So it will rank rows which contain sales and ccna higher than
> rows which contain only ccan or only sales.
That was what I was looking for.
BTW you said that FreeText would rank the rows. Can you do that with
Contains? I would like to do this in some cases.
Thanks,
Tom
> .
> "tshad" <tscheiderich@.ftsolutions.com> wrote in message
> news:upqxO%23aKFHA.1308@.TK2MSFTNGP15.phx.gbl...
>
|||actually I made a mistake, both FreeTextTable and ContainsTable will return
a rank value.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"tshad" <tscheiderich@.ftsolutions.com> wrote in message
news:O7wTZZbKFHA.3336@.TK2MSFTNGP09.phx.gbl...
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:OL0z5HbKFHA.436@.TK2MSFTNGP09.phx.gbl...
> That was what I was looking for.
> BTW you said that FreeText would rank the rows. Can you do that with
> Contains? I would like to do this in some cases.
> Thanks,
> Tom
>