This example shows how we might identify indexes needing defragmentation, using either REORGANIZE or REBUILD depending on the level of fragmentation. File: fix-frag
This example shows how we can use the pivot feature to display row values as column names. File: pivot-example