Change in indexes/relationships

We are having problems with the speed of our SQL Server. One of the
things I'd like to look at is the changes in the various indexes and
relationships. Is there any easy way to get the structure of the
entire db, or do I have to just go table by table and use the Ent
Manager "copy" command?
-Johnhttp://www.aspfaq.com/2209
This is my signature. It is a general reminder.
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"John Baima" <john@.nospam.com> wrote in message
news:8dct51lafs8g8cnisgrumksknqif6d03fd@.
4ax.com...
> We are having problems with the speed of our SQL Server. One of the
> things I'd like to look at is the changes in the various indexes and
> relationships. Is there any easy way to get the structure of the
> entire db, or do I have to just go table by table and use the Ent
> Manager "copy" command?
> -John|||Right-click the database in EM and there you have scripting options. Or use
any of the options
mentioned here:
http://www.karaszi.com/SQLServer/in...rate_script.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"John Baima" <john@.nospam.com> wrote in message news:8dct51lafs8g8cnisgrumksknqif6d03fd@.
4ax
.com...
> We are having problems with the speed of our SQL Server. One of the
> things I'd like to look at is the changes in the various indexes and
> relationships. Is there any easy way to get the structure of the
> entire db, or do I have to just go table by table and use the Ent
> Manager "copy" command?
> -John