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 |
magozeta
Starting Member
2 Posts |
Posted - 2011-10-11 : 03:37:14
|
Hello.I've upgraded sql server 2000 to 2008.I installed 2008 on new server and I Restored sql server's db 2000 to 2008.I noticed slow performance on query execution. Are there anything to do after restoring?Are there any difference with date management?(I noticed that query more slow when there are some getDate() or DateTime fields)thanks! |
|
Kristen
Test
22859 Posts |
Posted - 2011-10-11 : 04:01:19
|
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=80138 |
 |
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2011-10-11 : 04:17:07
|
1) run dbcc checkdb with all_errormsgs, data_purity on all your db.2) eventually run dbcc updateusage3) alter database set page verify checksum on all your db4) rebuild all indexes5) check you logins and users with sp_change_users_login 'report'6) ensure that you have activate instant file initialization7) update statisticsFranco |
 |
|
|
|
|