Originally posted by: rangda
What stevty2889 is saying is that very little of this stuff is eating up CPU time. av/as/firewall use very little cpu, and if you have active av/as scans they will be IO bound rather than CPU bound. Excel, Outlook, and Word do nothing but sit there and eat swap (and the occasional repaint) if you just leave the windows up and don't do anything. Unless you start a bunch of excel macros cranking to do some math and then tab off to another window.
SQL server could chew up serious IO as well as CPU/RAM depending on what you are doing, but I doubt you will be doing anything so seriously intensive on your local box. VS 2005 doesn't use much CPU at all unless you are using the ASP.NET or SQL reporting services designers, these seem to chug a bit (especially the ASP.NET designer, it's horrible if you flip it to xml mode; it does a first pass compile in the background as you change things to check for syntax errors.
I run a Q6600 because I tend to do things like do a video encode, run visual studio, and play everquest all at the same time.
For your situation you might be better off with a 15k SCSI disk than a quad core.

However I would strongly recommend you install vista x64 instead of x86 and get at least 4GB of ram. VS and SQL are memory pigs, you are going to need it. I run vista x64 and there is very little I have that would work in x86 that does not in x64. My (ancient) Strategic Sidewinder is one thing, and most of the overclocking/tuning apps don't work yet either (although SpeedFan, RivaTuner, and nHancer do). Pro audio stuff is largely not working at all in Vista, either x86 or x64. Most of these companies are taking their sweet time trying hard to pretend Vista does not exist. If you have a Creative sound card there may/may not be issues there, I have heard the drivers are shakey (I don't have a Creative card)