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 |
|
shaggy
Posting Yak Master
248 Posts |
 Posted - 2007-07-31 : 05:53:37
|
| dear friends,i have dropped many objects and recreated in a database.suddenly my database became very slow. so please any one of friends give solution. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-07-31 : 06:02:08
|
Update your statistics.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
shaggy
Posting Yak Master
248 Posts |
Posted - 2007-07-31 : 06:04:55
|
| can u please explain how to do |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-07-31 : 06:07:06
|
| EXEC sp_updatestatsSee BoL for more details.Kristen |
|
|
|
shaggy
Posting Yak Master
248 Posts |
Posted - 2007-07-31 : 06:10:50
|
| i will try and reply u kristen |
|
|
|
shaggy
Posting Yak Master
248 Posts |
Posted - 2007-07-31 : 06:21:50
|
| can anyone explain about sp_updatestats |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-07-31 : 06:47:06
|
| "can anyone explain about sp_updatestats"See BoL for more details.Kristen |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-07-31 : 08:07:01
|
| http://msdn2.microsoft.com/en-US/library/aa260337(SQL.80).aspxMadhivananFailing to plan is Planning to fail |
|
|
|
jhnegrao
Yak Posting Veteran
81 Posts |
Posted - 2007-07-31 : 13:02:14
|
| Have you rebuild your indexes? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-31 : 22:35:59
|
| Seems you forget to recreate index at all. |
|
|
|
|
|
|
database performance is very slow