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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-01 : 08:43:42
|
| Alan writes "HiFirst question: I have recently upgraded from SQL 7.0 SP3 to SQL 2000 SP2.With 7.0 I used to run usp_defragdatabase (script as obtained from http://www.swynk.com/friends/sharma/defragdb.asp) very frequently and with great success.With 2000 the query runs for hours and I am forced to abort it.Any idea why this would happen? On 7.0 it would complete in 30 minutes.Second question: I periodically run the "optimization job" from the standard maintenance plan within SQL 2000. What is the difference between this optimization job and other re-indexing queries like usp_defragdatabase mentioned in my question 1?Should I be employing both or just one?ThanksAlan" |
|
|
|
|
|
Difference between Optimization job and other re-indexing queries