I have recently started working with SQL Server 7. When I started there was
already a database set up and running, and they have asked me to fine tune it and improve
preformance. I would like to know if SQL Server 7 comes with any tools for creating an ER diagram
of the database. If you could recomend any online tutorials or books that would help me gain an
understanding of the Enterprise Manager, Profilers and Query Analyser, that would be much
appreciated.
Requires Free Membership to View
You can diagram database within Enterprise Manager. As far as books go, anything written by Joe Celko, Ken Henderson, or Itzik Ben-Gan/Tom Moreau will get you going in SQL. From there, you can pick up books by Richard Waymire, Sharon Dooley, Kalen Delaney, or myself (author listed as Stephen Wynkoop).
For More Information
- What do you think about this answer? E-mail us at editor@searchDatabase.com with your feedback.
- The Best Microsoft SQL Server Web Links: tips, tutorials, scripts, and more.
- The Best SQL Web Links
- Have a SQL Server tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical SQL Server questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
This was first published in May 2002
Join the conversationComment
Share
Comments
Results
Contribute to the conversation