Viewing 15 posts - 3,301 through 3,315 (of 18,926 total)
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...
August 11, 2011 at 2:26 pm
What can of monitoring do you have in place? That's you best bet at this time...
August 11, 2011 at 2:07 pm
NJ-DBA (8/11/2011)
For the record, I thought it was deprecated and gave him that answer on purpose!... didnt realize though that it is not technically a "self join".
Don't feel bad, she...
August 11, 2011 at 1:55 pm
If you love synchronicities you'll love the humor in this one!
http://www.sqlservercentral.com/Forums/Topic1158766-391-1.aspx
August 11, 2011 at 1:52 pm
:w00t: fitting OP name and thread icon to describe the use of nolock 😀
August 11, 2011 at 1:50 pm
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...
August 11, 2011 at 1:39 pm
most likely blocking or network wait or local processing wait.
I use profiler for this, much more accurate.
August 11, 2011 at 1:36 pm
Please post both plans. We can speed your way through that.
Otherwise you can read this whole, excellent, and free book about the subject.
August 11, 2011 at 1:34 pm
Hmm I would have expected a little more precision. Anyhow, how long did it take to run this time?
August 11, 2011 at 1:10 pm
Sounds like homework. What have you tried and where are you getting stuck?
August 11, 2011 at 12:52 pm
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...
August 11, 2011 at 12:19 pm
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
August 11, 2011 at 12:07 pm
Watched only 10 minutes of it but it goes in deep details about this issue... and it's from an MCM ;-).
August 11, 2011 at 11:59 am
Viewing 15 posts - 3,301 through 3,315 (of 18,926 total)