Ask the Expert

Help with tools to create database diagram

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

This was first published in May 2002

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: