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

There are some third party development tools like those from Apex SQL, Embarcadero, and Imceda. Not sure how GIU they are.

Halo 2.

Rented it Sun night and my little boy is all into it. Was playing this morning before school!

The only way to do this is self join or use code from a front end tool.

select comb, cnta, cntb, cntc

from ( select comb, count(*) 'cnta'

...