Common mistakes made while building and maintaining database
+ Add Slide
1
Inappropriate size of database

It is a common fault to use SQL Server management studio to create a database. This database has many options to reset size but as a common practise we go with the default sizing option. Apart from sizing in choosing data storage the log should also be sufficiently large if lot of insert or update operations have to be performed in your database. Make a rough estimate of the amount of data your project will need to store and only then choose the appropriate size.

Related
© 2012, Gizmowatch. Some rights reserved.