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 - 2003-01-01 : 15:07:05
|
| Magesh Babu writes "In the Windows OS if i want to de-frag my hard disk the os tells me that the hard disk re-quires a de-frag or not. Similarly is there any way i could find out wether a table needs DBCC INDEXDEFRAG to be executed or not." |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-01-01 : 23:06:54
|
| It only needs it if fragmentation is affecting performance or causing too much space to be used up.Look at dbcc showconfig in bol but it will only show fragmentation not it is up to you whether the system will benefit from doing anything about it.==========================================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. |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-01-01 : 23:14:06
|
| Did you mean:DBCC SHOWCONTIG? |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-01-02 : 06:06:44
|
| oops - ta.==========================================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. |
|
|
|
|
|
|
When do a Table need to de-fragmented