Very Computer

SQL 7.0 sp 2

After archiving some data, I need to release the unused space in data
file to the system. e.g. DBCC SHRINKDATABASE and DBCC SHRINKFILE didn't
work well. Do I need to reorganize every tables on the datafile? Is
there any kind of scripts/commands to check which tables are at the end
of the data file so that I can move them to a different datafile?
something like dbcc loginfo(databasename)?

Thanks a lot,

Shu

Sent via Deja.com http://www.deja.com/
Before you buy.

Shu,

From an architectural standpoint (I haven't had the need to shrink much myself, as I
preallocate space):

You don't have to reorganize first.
There is no problems with "tables at the end", such as there is with the log. SQL
Server moves datapages or rows to the beginning of the file for you.
--
Tibor Karaszi, SQL Server MVP
Please reply to the newsgroup only, not by email.
FAQ at: http://www.sqlserverfaq.com

After archiving some of my old data, I had the data file size around 18 GB
with about 5 GB unused. Even the autoshrink option was set to true, it took
some time for the system to reclaim the unused space. Now it's back to a
reasonable size now.

Appreciated,

Shu

Quote:> > Hello,

> > SQL 7.0 sp 2

> > After archiving some data, I need to release the unused space in data
> > file to the system. e.g. DBCC SHRINKDATABASE and DBCC SHRINKFILE didn't
> > work well. Do I need to reorganize every tables on the datafile? Is
> > there any kind of scripts/commands to check which tables are at the end
> > of the data file so that I can move them to a different datafile?
> > something like dbcc loginfo(databasename)?

> > Thanks a lot,

> > Shu

> > Sent via Deja.com http://www.deja.com/
> > Before you buy.