>
ASSUMING (Hint: verify with MS) Express licensing is per *cpu* and not *core*, I'ld guess you have nothing to worry about for the first year. As this new machine is relatively RAM starved (512 MB per core) anyhow, giving the maximum weight to Express by splitting between Express (2 cores and 1 GB) and other tasks IIS/ASP.net will probably give enough power to Express.
>
>As you plan to add other HW, adding a quad core data server should give you about 80% more CPU-bound processing power if you are cpu-bottlenecked. The main question probably is if 1 Gig of RAM for Express is enough to serve all queries. As long as the data is clearly less than that (leaving some RAM for Express itself and temp data) and you only run simple filtered selects or inner joins it should be no problem. If the data is larger than 1 GB and since the example you showed is heavily joined, as long as the relevant index data is kept in RAM, performance will probably be adequate. Hitting the disk before the last small step is the thing to avoid.
>
>If I remember Rick's statistics from a few years ago correctly, he ran similar amount of hits against much weaker HW also on SQL server. But perhaps his queries were simpler.
Yes, lots of things to consider.