"Daves" <dbspam@simnet.is> wrote in message
news:%23611A60IGHA.516@TK2MSFTNGP15.phx.gbl...
> err... is there something like "defragmenting" a database like we do with
> file system? My idea that after lots of ALTER TABLEs, ALTER COLUMNs,
> updates, inserts and deletes some master table could be irregularily
> scheduled because I notice the sql server is starting to work slower with
> the database although the data amount is not growing (i'm on the
> developement stage of a web site so no data only (changing) schemas)
>

"Michael Hotek" <mike@solidqualitylearning.com> wrote in message
news:el%23p2d2IGHA.2912@tk2msftngp13.phx.gbl...
> Take a look at the following in BOL:
>
> dbcc showcontig
> dbcc dbreindex
> dbcc indexdefrag
>
> If this is 2005, then you just need the alter index statement.
>
> --
> Mike
> http://www.solidqualitylearning.com
> Disclaimer: This communication is an original work and represents my sole
> views on the subject. It does not represent the views of any other person
> or entity either by inference or direct reference.
>
> "Daves" <dbspam@simnet.is> wrote in message
> news:%23611A60IGHA.516@TK2MSFTNGP15.phx.gbl...
>> err... is there something like "defragmenting" a database like we do with
>> file system? My idea that after lots of ALTER TABLEs, ALTER COLUMNs,
>> updates, inserts and deletes some master table could be irregularily
>> scheduled because I notice the sql server is starting to work slower with
>> the database although the data amount is not growing (i'm on the
>> developement stage of a web site so no data only (changing) schemas)
>>
>
>