That's about 200-2000 hours of training out of your league. I wouldn't...

TheSQLGuru (4/25/2012)

---

I didn't read the umpteen replies to the OP, but ANY TIME I see "ran slow the first time and very fast the second time" I IMMEDIATELY think the...

SpringTownDBA (4/13/2012)

---

The base...

Actually, hit save as sqlplan rather than show xml.

#1 - create temp table as coded already

#2 - Insert the results from the fts

#3 join back to the base table using the temp table to filter the correct results.

I...

Hey Steph, we can't help you if you don't reply. You have access to the greatest sql minds in the world, FOR FREE.

You might want to try to take...

P.S. You can upload the file rather than paste it, it's easier for us.

What happens if you run the query without the join? Just run the query with...

Any news?

We're all asking for the table's definition for a reason 😉

+1 on the tables def again. Looks like your clustered index is not optimal

*Perfmon.

He his a programmer, nice brain but I don't know if he has experience there. might need a lot more explainations on that front.

Did you change the query since you shared it with me? I don't remember having seen this hint before!

WITH(index=PK_RECHERCHE_CONTENU)

Hints are absolute last resorts and you're not there yet. ...

This is an estimated plan, we need the actual plan.

You can post as .sqlplan by hitting edit attachements

I already suggested that (direct contact before sending him here).

The problem doesn't happen only once, and there's too little data to be a problem unless it's hardware related (still in...

That handles deletions, but it can be adapted for anything else.

I've never tested it so I can't garantee how good it works.

http://raresql.com/2011/10/22/how-to-recover-deleted-data-from-sql-sever/