Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
amita
Starting Member
6 Posts |
Posted - 2012-11-09 : 04:24:06
|
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
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-11-09 : 06:53:12
|
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 provided3. 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 :) |
|
|
amita
Starting Member
6 Posts |
Posted - 2012-11-16 : 01:52:38
|
Hi sunita,Thanks for your reply.RegardsAmita kumariAmita kumari |
|
|
|
|
|