At this point you have all the cards. Start those process and dig through the logs for that time period.

Come back if you need more help.

The most I can...

What can of monitoring do you have in place? That's you best bet at this time...

Don't feel bad, she...

If you love synchronicities you'll love the humor in this one!

http://www.sqlservercentral.com/Forums/Topic1158766-391-1.aspx

:w00t: fitting OP name and thread icon to describe the use of nolock 😀

Please don't use no locks without knowing all the dangerous consequences : http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx

If you can't change anything index or table design wise, then there's not much we'll be able to...

most likely blocking or network wait or local processing wait.

I use profiler for this, much more accurate.

Please post both plans. We can speed your way through that.

Otherwise you can read this whole, excellent, and free book about the subject.

http://www.sqlservercentral.com/articles/books/65831/

... which he would read about in books online.

You might want to read up in left join.

Hmm I would have expected a little more precision. Anyhow, how long did it take to run this time?

Sounds like homework. What have you tried and where are you getting stuck?

I had no idea beyond maybe they are in an admin group. I'm really no expert in security. I just have 2 groups here. CEO group and...

You're in luck, very similar thread to yours going on at the moment. You can follow along but please don't hijack it.

http://www.sqlservercentral.com/Forums/Topic1158474-1550-1.aspx

Watched only 10 minutes of it but it goes in deep details about this issue... and it's from an MCM ;-).

http://technet.microsoft.com/en-us/sqlserver/gg508879.aspx