I am little bit confused about single core processor based SQL server or dual processor based SQL server.
We are planning to purchase SQL server 2008 Standard R2.
People are asking whether it is for single processor or dual processor. So, what's the difference between them?
If I've installed a single processor based SQL, then what happens?
My server has 2 quad core processors.