For Development, 2 smaller monitors anytime...a laptop and add-on flat screen. Add a docking station and a wireless network and you've got an ideal system. Add WWAN support and...

You'd actually want your comment to say that you are updating ALL the employee first and last names to the variable value. That would be an interesting comment! ...

Thanks for sharing, Simon! Everyone appreciates your candidness; and please pay no attention to the cranks.

I'm currently using Apex SQLEdit, which is working better for me than the your...

"Within each clinical trial, referential integrity is extremely important."

OK, good; it wasn't clear from your previous posts. If you go back over the forum posts for this topic, you'll...

Anthony,

Can't agree with you more. But calm down, I'm on your side, as is reason and experience! You seem to think...

Word, Anthony; but ouch! Can we just put this to rest? SQLServerCentral lets a lot of different people write articles, some with better ideas than others. Many...

"It's a variation of the "knapsack" problem. "

Darn...I was to to slow. Put I'll post my code anyway, as another variation of the same concept.

if object_ID('Payable') is not...

it's also important to note that temp tables are a sign of ineffective design and workarounds (usually performance related). In an ideally designed database (sitting on an ideally designed...

I tried this product a month ago. The CPU utilization goes up to 99% when it's sucking all the relational data in, but it drops back down after that....

select top 0 *

into temptable

from table

Insert temptable

select *

from table

Not that I'm saying to do this...the only reason to do "select into" is if you are selecting all the columns...

Great article, Don! This is extremely helpful....

heh heh...you said "poo".

That's a cool instrument, though.

Thomas, I certainly can't disagree that it is much harder. Yes, there are problems when you let users modify schema; and there are definitely at least a couple of...

Yeah, Ian, that vendor's database is a perfect example of how NOT to use MUCK tables.

Some people would agree with you that "For customer-defined fields - MUCK is probably the...