Gail, you're just too good.

Everything Jack said plus...

Have you defragmented or rebuilt your indexes in recent memory? If not, I'd do that.

Have you examined the execution plan to see where the bottlenecks in the...

Well, if you're going to build it out... probably more than one table, even several. I say this because I know that blocking information, deadlocks, and trace/profiler, data are all...

Thank you again. Feedback, positive or negative, is always welcome.

Thank you, but Books Online is better and much more complete.

You're in Full Recovery mode and have log backups in place right?

Yes, that's normal behavior. As noted above, if there are multiple statements within a stored procedure, each statement will have an individual plan. Each plan will show as a percentage...

Definately a Books Online topic. I did write a primer on backups & restores over here[/url]. I'd still hit BOL first.

Flush the procedure cache, dbcc freeproccache(), and then rerun the queries. I think MANU might have it. You inserted one table from the other. It's indexes are going to be...

I would definitely start with the trace to see which procedures are running long because I'll bet they're the same ones that are causing this problem. There are some great...

Blocking will require more than perfmon & profiler. Do a search in the scripts and you'll find some timed scripts that will gather that data for you.

SQL Server 2008 is...

Since you're already joining to the table, why not use the FREETEXT in the WHERE clause instead of joining the table to itself?

Whoops. I'm a moron.

Get the execution plan and it will tell you exactly what's occurring when. That's what they do.

You're pretty close

Yes, you need to drop the foreign key...