Touché? Sure man, whatever gets you through the night...

Look, I did answer them. Working with you on this has been a very trying process. If for some reason you *STILL* insist that I am somehow avoiding your questions, then use the following for an answer:
 
GREEN
 
That's right. So, in reference to both of your questions, my new answer is GREEN. GREEN is the way that SQL server does everything, and we have been keeping it a secret for a very long time. However, I am giving this information out from our secret lab in a trailer park in South Carolina (that doubles as a meth lab, you might have seen me on "COPS" a few times drunk and with my shirt off, but if you can't remember here's my picture):
 

 
That's me going over the wrap up code with Bill G. via a secure line. Oh sure, it *looks* like I'm just taking a dump outside of our "trailer", but that toilet is just a cover for our air supply to the lab (this was a practical joke, the programmers didn't think it was so funny).
 
So there you have it, and remember to think GREEN.

Hey all
 
well, i have read almost all of these post, and some GREAT! info in it.
 
Now,
 
@ my work i will be gett'n a new system
 
Specs will be:
 

Pentium 4 Processor at 2.40GHz with 533MHz system bus/ 512K L2 Cache
 
512MB PC800 RDRAM
 
DUAL (2 of them) 19 in (17.9 in viewable,.24-25AG) P992 FD Trinitron Monitor
 
128MB DDR NVIDIA GeForce4 Ti 4600 Graphics Card w/DVI and TV-Out
 
80GB Ultra ATA/100 Hard Drive
 
3.5 in Floppy Drive
 
Microsoft Windows XP Professional
 
Logitech Optical USB Mouse
 
10/100 PCI Fast Ethernet NIC
 
56K PCI Telephony Modem
 
24x/10x/40x CD-RW Drive
 
Integrated Audio with Soundblaster Pro/16 Compatibility
 
Harman Kardon HK-395 Speakers with Subwoofer
 
DVI-VGA Adapter to connect 2 CRT Monitors to Ti4600 or Ti4200 Video Card
[/list:u]
 
 
Now, lately i have been doing ALOT of gfx work, with PS , 3d studio.
, even though i will have 512mb of PC800, and an 80g ATA 100 HD
 
Would it be possibly a good idea to get a separate SCSI controller, and perhaps a small SCSI drive (5g or 10g), and make JUST that my swap / VM disk? and perhaps as well my PS scratch disk???
 
Would i really benefit alot as opposed to making a 5g partition off of the 80g drive?

With 512MB of RAM, you might as well make a small fixed-size swapfile. I use a GB of RAM on my dev boxes and try to pitch the swapfile altogether. Also, if you have access to the separate controller and drive then that might be a good idea. But, if you have to spend a fair amount of money on then I probably wouldn't bother as the performance increase you would see might be negligible.