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.
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.