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 |
|
Shah_Shaik
Starting Member
2 Posts |
 Posted - 2008-02-06 : 07:33:12
|
| Hi all,My ASP application is running fast in SQL Server 2000. But when we shifted it to SQL Server 2005, it becomes very slow.I have created the indexes also. There is lot of data in the tables.Is there any option to build the indexes for previous data.Please help....-Shah. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-07 : 00:32:34
|
| Tried update statistics or rebuild indexes? |
 |
|
|
Shah_Shaik
Starting Member
2 Posts |
Posted - 2008-02-12 : 00:11:35
|
| Thanks, I have rebuild the indexes. Its fast now. |
|
|
|
|
|
|
ASP application becomes slower in SQL Server 2005.