balasach82 (7/18/2013)
1. How to reduce this fragmentation in Clustered index at depth 4(in general for all depth rows)
Don't bother trying. The highest level is the root, which is only a single page.
2. How to reduce frag for NC which too are at 100%
Same way you do for a clustered index. Alter index ... rebuild or Alter index .. reorganize
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability