What’s New in Creating and Managing Indexes
The creation and management of indexes are among the most important performance activities in SQL Server. You will find that indexes and the tools to manage them in SQL Server 2014 are very similar to those in SQL Server 2012. There are, however, some minor changes to the index-oriented GUI screens. These changes include the ability to select the type of index that you want to create directly from the New Index menu and some organizational changes in the New Index screen.
Columnstore indexes were enhanced in SQL Server 2014. These indexes offer a powerful way to accelerate data warehouse workloads. You can now create a clustered columnstore index in SQL Server 2014. Also new to SQL Server 2014 is the ...
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.