Well to get the thread back "on topic" (as if), this one has managed to raise my blood pressure with his/her response.

Suffice to say. I'm done.

Samuel Vella (5/11/2009)

---

Also someone with 7 years DBA experience could well have only 6 months. The other 6 and a half years is really developer experience which they have fudged...

The issue is, the waitfor is not a part of the procedure itself. So the procs ran in the time reported. It sounds like you're trying to get client side...

I think Brent & Gail's advice is best. You have to get involved, somehow, with actual database work.

I started out in development by building apps and doing tech support...

Same question I was going to ask. Why only Indian authors? Wouldn't it be better to just go for the best books, regardless of the ethnic origin of the author?

For...

What you're proposing isn't an in-place upgrade. You're saying that you want to install 2005 on the same server as 2000 and them migrate the databases over. An in-place upgrade...

Using the ONLINE rebuild will reduce locking & contention but will increase tempdb use, so be read for that.

I wouldn't get too locked into particular time frames. It reall depends...

Since we've gone through two year searches in the past for DBA's, I sure can't tell you how to find them. While we weren't trying to get them to know...

I have yet to find a mechanism for reading the missing indexes DMV's and then connecting it to actual queries and query plans. Instead, I've used the fact that the...

OK. Forget the DTC. I'm just a moron.

However, size may be a factor. From the documentation:

Some Transact-SQL statements are not cached, such as bulk operation statements or statements containing string...

Does this proc include the use of DTC or is it called such that it uses DTC or extended procedures? I'm thinking it might be that the execution plan is...

Estimated costs are not always the best measures. However, a clustered index scan is the same thing as a table scan. So you need to adjust the query to make...

I didn't want bring up the cursor and add to your misery.

Have your core questions regarding the index scans & key lookups been answered for the moment?

Actually, if it's still in sys.dm_exec_sql_text and in sys.dm_exec_query_stats, then it's still in cache. It hasn't aged out yet. If it were not in cache, then not only would you...

Do you have the actual execution plan? Zip it up & post it.