m******y
发帖数: 588 | 1 We have a sql server database with the data file over 10 GB (transaction log
file is small), but there are not many tables or data in the db. I tried to
use DBCC shrinkdatabase and shrinkfile, but the size doesn't change much.
Also I created a database maintenance plan to reorganize data and index
pages, the size doesn't change either.
This database is used by several people who created and dropped tables often
. So I think probably the data pages in that db is fragmented. Is there
anyway to mak |
a*******t
发帖数: 891 | 2 do you have a lot of indexes? |
m******y
发帖数: 588 | 3 actually no clustered index are on any of the tables. Probably that's one of
the reasons the database size is big. I did check the table size, they are
all very small though.
【在 a*******t 的大作中提到】
: do you have a lot of indexes?
|
a*******t
发帖数: 891 | 4 what's the initial data/log file size?
of
are
【在 m******y 的大作中提到】
: actually no clustered index are on any of the tables. Probably that's one of
: the reasons the database size is big. I did check the table size, they are
: all very small though.
|
m******y
发帖数: 588 | 5 I don't know about it. sysfiles only have current size I believe. Is there
anyway I could check it? |
