Try using CHAR(9) instead of using a TAB from the Keyboard, like Doug suggested a few posts earlier.

I didn't spend anytime looking at your data types, but now that I have I do have some suggestions.

1. If the column contains dates then it should be one...

Just add that to the Where Clause.

SELECT

CHARINDEX(RTRIM(B.Words), U.url),

*

FROM

#urltbl U

CROSS JOIN #Badwords AS B

WHERE

...

Brandie Tarvin (1/3/2011)

---

Quick question for those on LinkedIn. I just received a message over the past two days (two messages actually) asking for advice on performance tuning tools. The messages...

Craig Farrell (1/3/2011)

---

For anyone following the earlier infringment discussion, some sleuthing around SSC finally revealed the blog owner. A brief PM conversation seems to have dealed with that issue.

Happy...

Happy New Year all! Hope none of you had to work over the holiday weekend.

Gus, congrats on 10K. Shows some perseverance. A year ago I thought I'd...

I recommend doing the aggregation in the query, if possible. I'm sure some of the problem is the aggregation.

We need the tables structures (including indexes), the query, and the execution plan in order to give any more advice.

GilaMonster (12/30/2010)

---

Don't just go and implement them. DTA's a pile of junk most of the time.

Take each recommendation. Test it. See if it improves the report and does not degrade...

LutzM (12/30/2010)

---

LutzM (12/30/2010)

---

Nope, not in the version I checked (will...

Without knowing the structure of the tables and the query it is hard to offer accurate advice.

How long does it take for the query to run in SSMS...

I'd bet the SafetyCheck is in the discussion of Jeff's article which I linked to in my original post.

It is definitely easier to find something if you know what you...

What type of mirroring are you using? High Availability, High Protection, or High Performance?

Are you updating statistics and doing index maintenance on the database in question? You could have a bad plan in cache because the distribution of data has changed. ...

in addition to Gail's and Grant's advice I'd suggest getting Adam Machanic's sp_WhoIsActive which will also give you the query text.

You can get the query text yourself using sys.dm_exec_sql_text().