I'd recommend you place your TEMPDB Log file on a different drive...

Seems like nice hardware for the server regarding CPU's but what about RAM and the disk subsystem? I...

Under Choose Data Source, use Microsoft Office 12.0 Access Database Engine OLE DB Provider - "Microsoft Access" is for Office versions lower than 2007

Have you tried inserting a tracer token to verify where the delay is actually occurring?

You can also create custom alerts (in your SQL Server Agent >> Alerts) via the SSMS,...

This happened on a couple of our servers before and while I can't remember the exact issue (it is typically related to autogrowth of the database files(s)), I remember this...

Per BOL (see if any of these are true for your situation) - maybe this table has an FK relationship to another table? Or you have CDC enabled?

If that...

"Dropping transactional replication" - exactly what did you drop? Just the publication? Subscription?

As far as I know it's not a bug, it's by design - If any table/article is included in any active publication, then it cannot be truncated. From BOL...

This should help - http://msdn.microsoft.com/en-us/library/ms188279.aspx

Thanks for the clarification Gail, I missed the != when I was editing it 🙂

Regarding the DISTINCT, yep, always test. As we all know what works great for a...

Okay. FYI the reason I asked about the data type for that column is because if it were a numeric data type and you placed quotes around it (effectively...

To answer your questions:

1. Merge Join - OK. For more info, check out this great article[/url] by Gail Shaw

2. The distinct forces SQL to go through all your results,...

No you cannot do this. Ref BOL here

Create a duplicate maintenance plan for both the full and diff, then script it out, delete the duplicate plan OR you could just script it out yourself? 😉

@ Jeff 😀

I believe you meant this - to the OP, this link will help greatly!

Bhuvnesh (3/5/2013)

---

In simple words.

Key/RID lookup means Non-clustered index is not covering all the participated columns in one query for one particular table. so optimizer choose the heap(RID) or clustered index(Key)...