Some suggestions

Hi,

I think it may be useful in SQL Defrag:

1. To see index script when I see the fragmentation of this index. Now I need to use another tool to do it.

2. Databases refresh (button?)

3. Now SQL Defrag is SDI, but sometimes I need to see the state of 2 databases in the same time.

Regards,
Oleg.

Parents
No Data
Reply
  • Thank you,
    1. To see index script when I see the fragmentation of this index. Now I need to use another tool to do it.

    Excuse my English.

    For example, I have selected index ix1 of table t in Defrag.

    I see the index fragmentation % and some other counters.
    But I do not know what fields are in this index etc.

    I need to see just here T-SQL DDL for this index, i.e.
    CREATE INDEX ix1 …..

    If I see the DDL then I can understand better why this index so fragmented.

    Now I run SSMS, go to this index ix1 and check its definition.

    Thanks.

Children
No Data