Re: Defragmentation of database file

From: Hari (hari_prasad_k_at_hotmail.com)
Date: 06/18/04 

Date: Fri, 18 Jun 2004 09:33:25 +0530

Hi,

Check the fragmentation for those tables using the below command

dbcc showcontig('table_name')

If the scan desity is too bad then execute

DBCC DBREINDEX('table_name')

for those table with high fragmentation.

Note:

It is not required to export and import data for tables. 

--
Thanks
Hari
MCDBA
"SY" <SY@discussions.microsoft.com> wrote in message
news:B95EB230-210D-4B40-96B6-5B7C05CACA7C@microsoft.com...
> We are using database having a current size of over 300GB to store
attachment files in an image column of a table. is the approach of exporting
and importing data records from the table a good way to defragment the
table? if so, is it possible to export the data records as a flat file to a
tape drive.
>
> thanks.
>
>
> "Tibor Karaszi" wrote:
>
> >
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "SY" <SY@discussions.microsoft.com> wrote in message
> > news:19838AE1-9327-49D1-BCE1-135AABE88F53@microsoft.com...
> > > Can I do the defragmentation of database file in SQL Server 2000, not
for indexes?
> > >
> > > Is the only way to export data from the database and then import back
into the database? If so,
> > how to do it?
> > >
> > > thanks.
> >
> >
> >

Relevant Pages

  • Re: Check database healthiness on a daily basis?
    ... > Thanks so much for your instance response, Hari. ... DBCC CHECKDB will run for a long time if your database is ... >> Monthly once check the fragmentation of table using DBCC ... >> THis will remove the fragmentation and increase the performance. ...
    (microsoft.public.sqlserver.server)
  • Re: Unable to handle database
    ... 5GB database size might not be a problem. ... DBCC SHOWCONTIG to identify thye tables fragmented and use DBCC DBREINDEX to ... remove Fragmentation. ... Check the usage of Transaction log using DBCC SQLPERF. ...
    (microsoft.public.sqlserver.server)
  • Re: Check database healthiness on a daily basis?
    ... that will be a better option to check and confirm that your database is ... DBCC CHECKDB will run for a long time if your database is ... Monthly once check the fragmentation of table using DBCC ... THis will remove the fragmentation and increase the performance. ...
    (microsoft.public.sqlserver.server)
  • Re: Check database healthiness on a daily basis?
    ... Thanks so much for your instance response, Hari. ... DBCC CHECKDB will run for a long time if your database is ... > Monthly once check the fragmentation of table using DBCC ... > THis will remove the fragmentation and increase the performance. ...
    (microsoft.public.sqlserver.server)
  • Re: MailMerge Word 2003 to Access 2000 query blank data
    ... If you select a query and run the MailMerge process you can see the ... > headers however you cannot see any data records. ... > database and informtion must be pulled at a minutes notice. ...
    (microsoft.public.word.mailmerge.fields)