While running a insert into a table statement the "new server" is running about 2 seconds slower per every 100,000 records. This is running the exact same statement, one running Win Server 2000 and SQL Server 2000 and the newer Win Server 2008 and
SQL Server 2008 and obviously a newer server for the 2008 stuff, by about 5 - 7 years. Apparently any write operation is 33% slower. Has anyone else seen this. I'm working on getting one of the statements our senior guy is complaining
about as I don't know which one he is exactally talking about. Read times on the new server seem to be faster though so this seems to be just during writing to a table. This is also in the Managment studio and not in any other software.
View Complete Post