ok, I have some weird behaviour on our new 64 bit box. When I do this: WHILE @Counter < 5000 BEGIN INSERT INTO Table VALUES(...) SET @Counter = @Counter + 1 END It takes forever. On any of our other boxes it's about 1 second. Now when I change the above statement to read: BEGIN TRANSACTION WHILE @Counter < 5000 BEGIN INSERT INTO Table VALUES(...) SET @Counter = @Counter + 1 END COMMIT TRANSACTION It's as fast as any other machine. So I'm guessing that the transaction ensures that only one commit happens, whereas the first query causes each INSERT to make a commit, slowing things down badly. My only problem is...why doesn't this happen on our other servers? Is there a 64 bit setting that might cause this? Or is it a database setting that happens to be different? Anyone have any insight into this? Any help would be greatly appreciated!