Defragmentation of table

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.
There are commands in SQL Server to defrag and reorg. I strongly suggest you start by reading below
excellent whitepaper:
http://www.microsoft.com/technet/pro.../ss2kidbp.mspx
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"SY" <anonymous@.discussions.microsoft.com> wrote in message
news:1dd4a01c454d4$11ae92f0$a301280a@.phx.gbl...
> 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.
>

Defragmentation of table

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.There are commands in SQL Server to defrag and reorg. I strongly suggest you
start by reading below
excellent whitepaper:
http://www.microsoft.com/technet/pr...n/ss2kidbp.mspx
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"SY" <anonymous@.discussions.microsoft.com> wrote in message
news:1dd4a01c454d4$11ae92f0$a301280a@.phx
.gbl...
> 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.
>

Defragmentation of table

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.There are commands in SQL Server to defrag and reorg. I strongly suggest you start by reading below
excellent whitepaper:
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" <anonymous@.discussions.microsoft.com> wrote in message
news:1dd4a01c454d4$11ae92f0$a301280a@.phx.gbl...
> 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.
>

Defragmentation of database file

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.
Hi,
Have a look into the below article.
http://www.winnetmag.com/SQLServer/A...283/24283.html
Thanks
Hari
MCDBA
"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.
|||http://www.microsoft.com/technet/pro.../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.
|||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 t
he data records as a flat file to a tape drive.
thanks.
"Tibor Karaszi" wrote:

> http://www.microsoft.com/technet/pro.../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...
> how to do it?
>
>
|||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.[vbcol=seagreen]
> thanks.
>
> "Tibor Karaszi" wrote:
http://www.microsoft.com/technet/pro.../ss2kidbp.mspx[vbcol=seagreen]
for indexes?[vbcol=seagreen]
into the database? If so,[vbcol=seagreen]

Defragmentation of database file

Can I do the defragmentation of database file in SQL Server 2000, not for in
dexes?
Is the only way to export data from the database and then import back into t
he database? If so, how to do it?
thanks.Hi,
Have a look into the below article.
http://www.winnetmag.com/SQLServer/...4283/24283.html
Thanks
Hari
MCDBA
"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.|||http://www.microsoft.com/technet/pr...n/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 dat
abase? If so,
how to do it?
> thanks.|||We are using database having a current size of over 300GB to store attachmen
t files in an image column of a table. is the approach of exporting and impo
rting data records from the table a good way to defragment the table? if so,
is it possible to export t
he data records as a flat file to a tape drive.
thanks.
"Tibor Karaszi" wrote:

> l]
> --
> Tibor Karaszi, SQL Server MVP
> [url]http://www.karaszi.com/sqlserver/default.asp" target="_blank">http://www.microsoft.com/technet/pr...ver/default.asp
> http://www.solidqualitylearning.com/
>
> "SY" <SY@.discussions.microsoft.com> wrote in message
> news:19838AE1-9327-49D1-BCE1-135AABE88F53@.microsoft.com...
> how to do it?
>
>|||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.[vbcol=seagreen]
> thanks.
>
> "Tibor Karaszi" wrote:
>
http://www.microsoft.com/technet/pr...n/ss2kidbp.mspx[vbcol=seagreen]
for indexes?[vbcol=seagreen]
into the database? If so,[vbcol=seagreen]

Defragmentation of database file

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.Hi,
Have a look into the below article.
http://www.winnetmag.com/SQLServer/Article/ArticleID/24283/24283.html
--
Thanks
Hari
MCDBA
"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.|||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.|||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.
>
>|||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.
> >
> >
> >

Defragment SQL Database File

I am trying to defragment our sql database file but windows defragmentation
tool defragments everything but the database file. I have tried detaching the
database and stopping the services but with no luck. Drive size is 82 Gb and
file size is about 45 Gb. The file is in 2 fragments and records a 99% file
fragmentation level. Does anyone have any ideas how I can defrag this file?
Thank you
Clint ColefaxClint
Look at DBCC SHRINKFILE command in the BOL.
"Clint Colefax" <ClintColefax@.discussions.microsoft.com> wrote in message
news:B7892BF8-05E9-459A-B70E-844612937AC7@.microsoft.com...
> I am trying to defragment our sql database file but windows
defragmentation
> tool defragments everything but the database file. I have tried detaching
the
> database and stopping the services but with no luck. Drive size is 82 Gb
and
> file size is about 45 Gb. The file is in 2 fragments and records a 99%
file
> fragmentation level. Does anyone have any ideas how I can defrag this
file?
> Thank you
> Clint Colefax|||And to avoid such fragmentation in the future, check out:
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Uri Dimant" <urid@.iscar.co.il> wrote in message news:%23Zy%23K7NDFHA.2764@.TK2MSFTNGP10.phx.gbl...
> Clint
> Look at DBCC SHRINKFILE command in the BOL.
>
> "Clint Colefax" <ClintColefax@.discussions.microsoft.com> wrote in message
> news:B7892BF8-05E9-459A-B70E-844612937AC7@.microsoft.com...
>> I am trying to defragment our sql database file but windows
> defragmentation
>> tool defragments everything but the database file. I have tried detaching
> the
>> database and stopping the services but with no luck. Drive size is 82 Gb
> and
>> file size is about 45 Gb. The file is in 2 fragments and records a 99%
> file
>> fragmentation level. Does anyone have any ideas how I can defrag this
> file?
>> Thank you
>> Clint Colefax
>|||Tibor
You are not added yet "Search" engine on your web site :)
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:unTZdvQDFHA.328@.tk2msftngp13.phx.gbl...
> And to avoid such fragmentation in the future, check out:
> http://www.karaszi.com/SQLServer/info_dont_shrink.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23Zy%23K7NDFHA.2764@.TK2MSFTNGP10.phx.gbl...
> > Clint
> > Look at DBCC SHRINKFILE command in the BOL.
> >
> >
> > "Clint Colefax" <ClintColefax@.discussions.microsoft.com> wrote in
message
> > news:B7892BF8-05E9-459A-B70E-844612937AC7@.microsoft.com...
> >> I am trying to defragment our sql database file but windows
> > defragmentation
> >> tool defragments everything but the database file. I have tried
detaching
> > the
> >> database and stopping the services but with no luck. Drive size is 82
Gb
> > and
> >> file size is about 45 Gb. The file is in 2 fragments and records a 99%
> > file
> >> fragmentation level. Does anyone have any ideas how I can defrag this
> > file?
> >>
> >> Thank you
> >> Clint Colefax
> >
> >
>|||Thanks for the reminder Uri. It is still on the to-do list, but other things keep getting popped on
the stack before I get to do this one. ;-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Uri Dimant" <urid@.iscar.co.il> wrote in message news:%23mkEydRDFHA.1280@.TK2MSFTNGP10.phx.gbl...
> Tibor
> You are not added yet "Search" engine on your web site :)
>