Craig Farrell (7/18/2011)

---

Without seeing your sample data, I had to make some assumptions. Don't where clause AFTER you initiate the ROW_NUMBER(). That's what's removing the rows on you....

Thanks Sean!

I am not using an SP, i am using

"InsertIntoDocuments(strFileExtension, fileName + strFileExtension, TextBoxResume.Text);".

I wonder if it is an IIS issue?

Thanks !

Thanks!

I tested with the LIKE statement and got this one down to 2 secs 🙂

Are you saying that i should stick with CONTAINS for searching much larger strings, eg, a...

Derrick Smith (1/25/2011)

---

Contains() is a much more powerful command and for your purposes I think it's overkill for a string lookup.

Note the missing index warning at the top of...

Please find attached the execution plans.

One using the 'like' statement and one using the 'contains' statement.

Thanks!

I ran an execution plan, but dont really have any experience in this area, so i opened a ticket with Microsoft.

Thanks again!

I have defined FTI on the field i am searching.

Thanks for your suggestions!

It was being used as a test DB and i would like to get rid...

Could this happen with a faulty o/s installation?

Thanks

declare @Query as varchar(8000)

declare @Name as varchar(250) ...

Lowell,

That work great!

Thanks.

I am logged into SSMS as 'sa'.

The exact error message is 'Access is Denied'.

Worked great!

Thanks.