Thanks @Jangita and @John. Will look at the current set configurations of the DB attribute types and lengths.

@Rad The current DB stands at 250Gib, the log file used to be bigger than the DB hence we run a Job to shrink the Log and the DB everyday as part of DB Maintenance. Shrinking is our8 temp solution of freeing any unutilized space and compressing the log


On Wed, Feb 19, 2014 at 5:25 PM, Rad! <conradakunga@gmail.com> wrote:
1) What do you mean by 'grows significantly'
2) WHY do you want to shrink it?


On Wed, Feb 19, 2014 at 3:59 PM, Tusker 21 <tusker212@gmail.com> wrote:
What is the best way to maintain a database that grows significantly. Currently i am using DBCC Shrink command. However this is said to have performance issues as the indexing of the DB is affected. 

Any guru n the list who can assist?

R,
T21

_______________________________________________
skunkworks mailing list
skunkworks@lists.my.co.ke
------------
List info, subscribe/unsubscribe
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------

Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke


_______________________________________________
skunkworks mailing list
skunkworks@lists.my.co.ke
------------
List info, subscribe/unsubscribe
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------

Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke