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.
> >
> >
> >

Defaulting the export option

Is there a way to control the contents of the report export drop down
list? Specifically, I would like to set a default export to PDF
(instead of the "Select a format" entry)You can force the rendering format for that report but I don't think there is
a way to default the drop-down selection.
Here is a PDF render format against the AdventureWorks sample reports (the
report gets generated in PDF):
//localhost/ReportServer?/AdventureWorks Sample Reports/Company
Sales&rs:Format=PDF&rs:Command=Render
"Paul" wrote:
> Is there a way to control the contents of the report export drop down
> list? Specifically, I would like to set a default export to PDF
> (instead of the "Select a format" entry)