Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

object oriented DB Expand / Collapse
Author
Message
Posted Thursday, July 07, 2011 7:39 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 11, 2014 8:15 AM
Points: 8, Visits: 136
Greetings,

We have implemented a close approximation of an OOBD in MSSQL 2005 for a department of ~100 staff in a larger financial institution.

While the volume of data will likely never be unmanageable, we are still looking ahead at possible future hurdles.

The db consists of 4 tables with limited number of sp. Indexing speaks to most issues when six of the seven fields form the composite key.

So the few 'plans' never change. Backup will be interesting because it may impact indexing. For this instance, could someone perhaps clarify the '20%'?

We could make the assumption that every 2 months we hit the 20% benchmark. What then, maintenance plans?



Post #1138135
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse