469,133 Members | 1,023 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,133 developers. It's quick & easy.

database information report

I am trying to use the SQl Server database reporting tools to create a
report on the database to find areas for optimization including table
formats, column formats, and sizes. Can anybody please help me with
this. If any body has used any other tool by which I can create above
mentioned reports plz do let me know. I will be really thankful for
your help.


Jul 17 '07 #1
1 1038
Will the report output just the schema, or are you looking for a
report to make suggestions on things like shortening column lengths
and missing indexes? A place to start would be the INFORMATION_SCHEMA.
All DB's have available many tables like INFORMATION_SCHEMA.COLUMNS.
Lookup in BOL.

Jul 17 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

24 posts views Thread by Michael Malinsky | last post: by
4 posts views Thread by Grant Stanley | last post: by
8 posts views Thread by RibGnaw | last post: by
12 posts views Thread by Ray | last post: by
3 posts views Thread by route_coder | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.