Prev: Reduce log file size
Next: Update whit values from other table
From: Prasad Behere on 13 Aug 2010 01:35
Hi All,

I have a production database which was of 20 GB of size.

I tried to put up one clustered indexe with three key coulmn, few other
non-clustered indexes.

After running for about 2 hours the size of datafiles grew up to 103 GB!!

Can someone advise why this happened and any solution to bring the size down?

Thankfully,
Prasad
 | 
Pages: 1
Prev: Reduce log file size
Next: Update whit values from other table