Database size increasing

Hi all,
When are performing data upload into our system the size of the database
increases very high . Only after we defrag does the database size decreases.
We have tried setting the autoshrink option as true but it still does not
work. Is there any alternative.Probably due to page splits. Read about fillfactor and also consider what indexes you have,
especially the clustered index. Also, use DBCC SHOWCONTIG to analyzer page fullness (sign of page
splits).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Srini" <Srini@.discussions.microsoft.com> wrote in message
news:0593003C-3144-456A-AF16-BC9A93F71FAD@.microsoft.com...
> Hi all,
> When are performing data upload into our system the size of the database
> increases very high . Only after we defrag does the database size decreases.
> We have tried setting the autoshrink option as true but it still does not
> work. Is there any alternative.|||Hi srini
Try using
DBCC SHRINKDATABASE:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_dbcc_217n.asp
DBCC SHRINKFILE :
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_dbcc_217n.asp
It is not a good practice to defrag when the SQL Server is running.
does this answer your question? or do u require any more information
best Regards,
Chandra
---
"Srini" wrote:
> Hi all,
> When are performing data upload into our system the size of the database
> increases very high . Only after we defrag does the database size decreases.
> We have tried setting the autoshrink option as true but it still does not
> work. Is there any alternative.