Tag Info

New answers tagged

4

Much of this is a matter of taste and style. And more importantly: specific requirements and consistent conventions. However, there are good reasons for this generic advice: CREATE TABLE item ( item_id serial PRIMARY KEY, grp_id integer NOT NULL REFERENCES grp(grp_id) ); If you have an item_id, better make it unique and ideally a surrogate ...


0

I've seen plenty of single-server solutions with IIS and SQL, some with 4 GB of memory. They work for low-load situations. I wouldn't want to run a busy site unless there was a lot of memory to work with. If you have enough memory for the load, the lower latency of communicating over shared memory, instead of the network stack, could be a net win. If ...


0

When there's nothing else on the machine besides SQL you need to leave at least 2-4 Gigs of RAM for the OS. When running a bunch of different IIS sites you'll need at least 4 Gigs for the OS and IIS. As some of your machines have only 4 Gigs that's a bit of a problem. Can you add some RAM to these servers to get them up to 16 or 24 Gigs? I'm assuming x64 ...



Top 50 recent answers are included