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 - 2001-08-11 : 16:36:20
|
| Alan writes "I have used, with great success, the script for defragmenting my database on:http://www.swynk.com/friends/sharma/defragdb.aspHowever in my search for more information on the subject, I also found this resource with regard to re-building indexes:http://www.sql-server-performance.com/rebuilding_indexes.aspThey are similar, but the second one has options for "fillfactor". My database experiences more writes:reads, which may indicate that I should reduce my fillfactor from 100%.My question is: should I implement both, or if only one is necessary, then which one do you think is more useful.ThanksAlan" |
|
|
|
|
|
Derfagmenting SQL 7.0 dB