How to Reindex SQL Tables. The indexes on a the tables of a large database make a huge difference in its performance and utility. Without an index, locating a single record in a large table can ...

As part of my weekly maintenance routine, I rebuild the indexes on several of my larger high-activity tables. I'd like to try and get an idea of just how long the rebuilds take.

Non-clustered Columnstore Indexes are also getting some enhancements in SQL Server 2016. The most notable of these enhancements is the ability to be updated.