I’ve been working with AGs for the last year and have a couple of things as regards indexing that I thought would be good to share: Always sort in tempdb When you create, or rebuild an index you have the ability to have the index perform the sort of the data inside of tempdb. This…