Gail,

I was not implying you do not 'pay it forward', you most certainly do, and always have!

I was referring to Sean.

Apologies for the confusion.

Ian

GilaMonster (10/5/2013)

---

isuckatsql (10/4/2013)

---

Sean, you make a lot of suggestions about all the things i am doing wrong, yet offer nothing helpful.

This is a discussion forum, so we discuss things, if...

Thanks Luis and Gail for your help.

Sean, you make a lot of suggestions about all the things i am doing wrong, yet offer nothing helpful.

This is a discussion forum, so...

Its a work in progress, so its the best i have so far.

What is interesting is that Microsoft DBA's could not even get the query quicker than 5 seconds !...

In testing the sub queries proved faster than Joins, as did the MAXDOP and NOLOCK.

The data returned, in before and after testing of the above hints, was the same.

This query...

Thanks

Thanks for the feedback !

So how does Ebay do it?

If you go to the Ebay Motors section, they only display 25 records, but when you use the 'sort by' feature,...

Thanks !

The words that would typically be searched are IT related, such as Java, J2ee, JQuery, Livelink etc...

Since i don't know every new technology being developed, it is easier to remove...

Thanks!

Erland Sommarskog (9/15/2013)

---

If you have all the words you want to add in a table, you can do

SELECT 'ALTER FULLTEXT STOPLIST MyStoplist ADD ' +

...

Would creating empty stoplist, then importing my 10k stopwords work ?

Thanks

I found the problem !

The data structure for the text file provided by the client was wrong ................... duh !!!!!!!!!!!

It was actually a COBOL data structure, i have...

Thanks for all the feedback!

Michael,

I just changed from dynamic sql to structured sql, due to concerns about sql injection !

..... and so the digging continues.

Thanks for the feedback !