February 1, 2010 at 3:44 am
I have been given a task of improving our old db or making a brand new db.
Although i think making a new db will be not very good idea but our old db can be improved.
The current db is not normalised and miss many thing (right from FK to IX)
Any suggestions on my thinking is helpful.
Also, if I were to start improving old db where do i get started/which things should be kept in mind.
(I have ran profiler/tuning advisor many times.. but no good ideas)
Thanks
Khushbu
February 1, 2010 at 7:11 am
If you have the option to improve performance and data integrity by adding foreign keys and indexes to the current database I would start there.
You also have to consider how you are doing data access because if your application depends on direct table access it will be much harder to make schema changes in the existing database beyond FK's and IX's. If you are doing access through views/stored procedures/functions then you can do more with schema changes in the existing database.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 1, 2010 at 7:30 am
Further to what Jack said.
First, what is it are you trying to improve? I think you first need to list out issues with the existing database. Then figure out what you need to do.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply