Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sql777
Constraint Violating Yak Guru
314 Posts |
 Posted - 2007-07-03 : 15:00:47
|
| Hello,Assuming the exact same setup (same db, data, procedures, server specs etc) has anyone seen any performance data comparing SQL 2005 versus 2000?How about when they converted over to take advantage of sql2005's new features, how was performance effected? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-03 : 23:49:39
|
| Depends on how you query table. You need rebuild index and/or update statistics after moving db to sql2k5, otherwise may get worse performance. |
 |
|
|
Kristen
Test
22859 Posts |
|
|
|
|
|
Performance of Sql 2005 versus 2K