Mike,

Apologies, a typo in the filename. It's fixed.

Bob is correct. The question is testing how you accomplish a task, which is what many examinations or interview questions will do. If you got this in a pre interview...

Sorry, that's the best answer of those that are available. You can always attach the errorlogs to the email that will contain the sqldiag output. The answer is correct, perhaps...

I tend to agree that MS hasn't introduced security very well into their products. There are some very smart people up there and I know many of them understand how...

That's strange. I'll have to give that a try, but I wouldn't expect that to be the problem.

Any query could peg your server at 100%. In fact, I've had lots of servers that would hit 100% for a minute or two.

Today there isn't anyway to determine this...

Is this data compression inside the database? You could probably use any type of zip tool to compress data before you put it in, but it would make searching impossible.

The...

It's probably a link issue between the servers where one is too busy to respond quickly if it's not a consistent problem.

Brian,

Thanks. It happens sometimes as they update their filters and catch us for some reason.

I removed you.

No one sent me any comments

My mistake. Thinking of other languages. It's been corrected.

Maybe. It's an interesting concept. We have had a few people do reviews on their own, but for the most part, our authors don't. Perhaps we should call out the...

I do not think so. Profiler really helps here, but that requires SA access. There is an article on this site about tracing deadlocks.

http://www.sqlservercentral.com/columnists/skumar/tracingdeadlocks.asp