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 - 2006-01-20 : 08:26:39
|
| lance writes "can you defrag a SQL Database??? I am hearing yes and No...thanks,Lance" |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-01-20 : 08:51:58
|
| Not using defrag you can't. You would need to re-organise your pages and then shrink the file if its a optimisation or space issue. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-01-20 : 10:49:55
|
| Hi Lance, Welcome to SQL Team!What we do is:1) Allow the files to grow to a reasonable "working size"2) Use SQL's DEFRAG / REINDEX to tidy everything up (which may increase the "working file size")3) Take the database off-line and defrag the physical filesKristen |
|
|
|
|
|
|
Defrag a SQL database