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 for the feedback.
>>I’m not sure I fully understand this request. Will you please elaborate a little more on what you are looking for?
>> Have you tried clicking on the instance name and selecting ‘Rediscover database objects’? That should refresh the list of databases, tables and indexes.
>>We appreciate the suggestion. I will add this to our list of feature enhancement requests. If you have any more information you would like to share about what it is you are doing/comparing when looking at the two databases simultaneously, that would be great.
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.