Microsoft SQL Server 2012 Internals

Conclusion

This chapter discussed index concepts, index internals, special index structures, data modifications, and index management. You looked at the new SQL Server 2012 technology called columnstore indexes and described how their storage is different from other nonclustered indexes. This chapter covered many best practices along the way and, although performance tuning wasn’t the primary goal, the more you know about how indexes work internally, the more optimal structures you can create. Finally, by understanding how SQL Server organizes indexes on disk, you can be more adept at troubleshooting problems and managing changes within your database.