. . . Anyone have thoughts on The Dixie Flatline's fine solution? Hopefully conclusions won't depend on a video GPU or sound card or anything like that :hehe:
. . .
Are you saying that SELECT...INTO is 10% faster on Sandy Bridge than CREATE TABLE + INSERT INTO on Nehalem?
Or is it that SELECT...INTO on Sandy Bridge 10% faster than SELECT...INTO on Nehalem? . . .
Yes, parallelizable queries are faster on Sandy Bridge.
Re results varying depending on GPU, you may expect that in the next version of SQLS: the new version of Visual Studio has heavy focus on async and parallelization, and the newest generation of NVIDIA cards, such as Tesla C2050, double as vector processors. I think that SQLS guys will take advantage of that, if it is available.