Resources


Proper maintenance and tuning of indexes is a critical part of a database administrators job. This Whitepaper explores the differences between heaps and clustered tables, and between clustered indexes and nonclustered indexes. In addition to properly designing indexes in the first place, monitoring their use over time can help with eliminating unneededindexes and adding new beneficial nonclustered indexes. As the data is updated, the efficiency of indexes can decrease because of fragmentation. Periodic index maintenance eliminates or reduces fragmentation so that performance of applications and reports does not decrease over time which is also discussed in this Whtiepaper.

Download SQL Server Indexes Whitepaper

Digital Transformation

Today’s corporate strategy is focused on transforming their use of technology and data. Pragmatic Works has been the leader in digital and data strategy for over a decade. We partner with you to find atransformation plan and then execute it together.