Online Indexing Operations
One of the great features available with SQL Server 2014 is online indexing. This feature, available only with the Enterprise or Developer Edition, allows you to create, rebuild, or drop indexes without having exclusive access to the index or table. This means that users can continue to access the underlying tables and indexes while the index operation is in progress. This bodes well for high-availability applications and databases that have limited downtime available for offline operations.
Note
SQL Server 2014 continues to offer extended support for online index operations. In versions prior to SQL Server 2012, indexes that include large object (LOB) or XML data, or clustered indexes on tables with LOB or XML columns, ...
Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
