might be with regards to hyperthreading.. ..windows 2003 works better with hyperthreading than 2000.. ..but then again it's a debate whether you turn hyperthreading on for sql anyway..

Simple answer to the question would be:

Declare @x INT, @y INT

SELECT @x = 1

SELECT @y = 2 --(Could have a select statement to get a max value here)

WHILE @x <=...

Hi Moreno

Sounds a fun one  Have set Affinity Masking?  If you want sql to use all processors leave it as default.....