5 PCs and a PS2 that are used virtually every day. But I still don't have digital cable or HDTV.

I'm thinking of scavenging some older pcs and fiddling around...

And further more ...

Suppose you consolidate the DBs and as a part of weekly maintenance you run a dbcc checkdb repair_fast. This requires...

Well, for what it's worth, we run several hundred databases in our environment. It creates some adminstrative headaches and some things (like starting and stopping the service) are very slow,...

No harm, no foul.

I for one appreciate the effort you guys put forth in creating these things. But we all like to complain a bit

It only asked if it was possible. Anything is possible. Such a broadly stated question is the bane of IT. Good specs always make for a better outcome. Plus, it's...

This was my thinking. Seems to me that since we were given latitude in setting requirements for the developer, the best approach would be to have him submit his request...

OK. I'm confused. The question says the error is because of a duplicate primary key in the publisher, but all of the answers deal with the subscriber or agent. It seems...

Still don't think it's a bug.

This fails:

1) select 999999999 * 11

But these dont'

2) select 99999999 * 11

3) select 9999999999 * 11

I believe what is happening is that SQL Server uses...

Not a bug, but a type conversion problem.

This works:

declare @tmp numeric(38,4)

declare  @tmp2 bigint

set @tmp2=999999999

set @tmp = @tmp2 * 11

select @tmp

I stand corrected.

It is actually a very powerful language in what it allows you do to. It is, again IMHO, a weak language...

So who invented T-SQL?

IMHO, this is a really good example of the weakness of the language. Implicit type conversions are dangerous in general, but...

WOW!

That question was worth twenty one points!!!

It's been my experience that QOD runs hot and cold and we are in a bit of a cold spell. Sometimes it really makes you think.

My problem with this question...

Hence my preference for strongly typed languages. IMHO, code like that should not pass a code review. If you ever expect a string value to be assigned to an integer value,...

Thanks for the explanation on this. I thought something strange along these lines could happen but I really wasn't sure what was going on. It makes perfect now sense since...