iii Contents
Contents
Introduction .............................................................................................................................................. viii
Who should read this book .............................................................................................................................................. viii
Assumptions ....................................................................................................................................................................... viii
This book might not be for you if… ............................................................................................................................... viii
Organization of this book ................................................................................................................................................... ix
Conventions and features in this book .......................................................................................................................... ix
System requirements............................................................................................................................................................. ix
Prerelease software ................................................................................................................................................................. x
Acknowledgments ................................................................................................................................................................... x
Errata, updates, & book support ....................................................................................................................................... x
Free ebooks from Microsoft Press .................................................................................................................................... x
We want to hear from you .................................................................................................................................................. xi
Stay in touch ............................................................................................................................................................................. xi
Chapter 1 Faster queries ......................................................................................................................... 1
In-Memory OLTP enhancements ....................................................................................................................................... 1
Reviewing new features for memory-optimized tables ....................................................................................... 2
Scaling memory-optimized tables ............................................................................................................................... 2
Introducing native client enhancements ................................................................................................................... 3
Exploring T-SQL enhancements .................................................................................................................................... 3
Managing memory-optimized tables ......................................................................................................................... 5
Planning data migration to memory-optimized tables ....................................................................................... 6
In-memory analytics ............................................................................................................................................................... 8
Reviewing columnstore index enhancements ......................................................................................................... 8
Getting started with in-memory analytics ................................................................................................................. 9
Using filtered columnstore indexes ............................................................................................................................. 9
Analysis Services enhancements..................................................................................................................................... 11
Understanding multidimensional performance improvements .................................................................... 11
Understanding tabular performance improvements ......................................................................................... 12
