SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 learning new database and functionality
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

amita
Starting Member

India
6 Posts

Posted - 11/09/2012 :  04:24:06  Show Profile  Reply with Quote
Hi experts,

please tell me how quickly to learn and maintain huge database.If we have 40 to 50 tables in our database how quickly i can know about them.

Amita kumari

sunitabeck
Flowing Fount of Yak Knowledge

5155 Posts

Posted - 11/09/2012 :  06:53:12  Show Profile  Reply with Quote
A few things:

1. Talk to business users or other developers/DBA's to get an understanding of the business logic that the database is supporting.

2. Read up any documentation that previous developers and/or the vendor has provided

3. Use SQL Server's database diagrams capability to visualize the tables and relationships - for me, this is one of the best tools for getting a sense of the lay of the land.

4. Look at the stored procedures, views, functions to see what they do , what the signatures are, which business clients make use of them, how they affect the tables and databases etc.

5. Experiment with the database in a development environment.

In other words, a lot work :)
Go to Top of Page

amita
Starting Member

India
6 Posts

Posted - 11/16/2012 :  01:52:38  Show Profile  Reply with Quote
Hi sunita,

Thanks for your reply.



Regards
Amita kumari

Amita kumari
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000