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 |
|
rnbguy
Constraint Violating Yak Guru
293 Posts |
 Posted - 2007-01-02 : 00:50:02
|
| hey guys for some reason when i run this:USE WebPageLog;GOALTER INDEX PK_TNS_report ON TNS_reportREBUILD;GOthen i check index fragmentation its still the same 50% why is that? |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-01-02 : 05:47:02
|
| do you have multiple datafiles? is this a small or large index?-ec |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-01-02 : 08:00:14
|
| fillfactor?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
rnbguy
Constraint Violating Yak Guru
293 Posts |
Posted - 2007-01-02 : 18:42:28
|
| fill factor is 0 (default) on all, id like to change this but not sure how much to set it too ill have to do some reading on that... multiple datafailes???there are quite a few different index sizes, some have 20 records some have upto 30,000+ |
|
|
|
|
|
|
ALTER INDEX