Have you captured the query being run by the report and run it in SSMS to view the execution plan to determine if you can optimize the query? If...

In copyrighted works there is often a disclaimer that states that you can quote the work without permission as long as the quote is less than a certain percentage of...

Please read the top article in my signature for how to post code in order to get the fastest and most accurate answers.

Here are some questions I need answered in...

You are basically using the "quirky update" which is explained in detail by Jeff Moden in this article, http://www.sqlservercentral.com/articles/T-SQL/68467/. I think he addresses your concerns in the article.

Okay, it took me a few minutes, but here's code that works with your sample:

SELECT

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

*

FROM

#urltbl U

...

One thing you have to be careful of is that the job history log is limited, so if you have a lot of jobs running, you may lose that data.

Wow, SharePoint as highly critical, what is this world coming to?

Seriously though. There are many differences between clustering and mirroring. Here are few:

1. Clustering covers the entire...

As others have said, there is no hard and fast rule.

My rule of thumb is start with fewer db's, monitor load and add or remove databases as needed based on...

I can't believe that she's doing...

You can't tell how short I am...

Hey, did you know that SSC is now a dating site? Here's a PM I got from lord.god90:

Hello My New Friend.

Good Day and How are you today.

Please do not...

on blogging:

I'm on blogger and syndicated here. If I had to do it over again, I'd start with a free wordpress account instead of blogger because I think wordpress...

Now listening to Jeff's Tally Table session on the PASS Summit DVD. Now I have a voice to put with his posts.

It is always fun to see debates going on for a topic 3 months after the original post.

For my part, since there is no real difference between the 2 I...

Merry Christmas all.

And no, I won't be politically correct. If you don't celebrate Christmas please don't be offended as that is your right.

I hope everyone has a...