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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2007-05-28 : 05:12:02
|
| Dear Experts, what exactly the defragmentation in sql server? what is the useVinodEven you learn 1%, Learn it with 100% confidence. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-05-28 : 05:55:12
|
| this is most likely by defragmentation of indexes._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2007-05-28 : 06:41:19
|
| is there any script to do this? and is it not a problem dropping and reconstructing the indexes?VinodEven you learn 1%, Learn it with 100% confidence. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-28 : 12:21:25
|
| You can check it with 'dbcc showcontig', rebuilding clustered index can defrag table. You may also have file frag on the server, need disk defrag tool to handle that. |
|
|
|
pootle_flump
1064 Posts |
Posted - 2007-05-28 : 14:37:20
|
quote:
Originally posted by sunsanvin
what exactly the defragmentation in sql server?
http://www.sqlservercentral.com/columnists/chedgate/fragmentation101.aspYou might need to do some further reading around the subject about how SQL Server stores data, extents, pages, page headers etc.. |
|
|
|
|
|
|
what is meant by database defragmentation?