Microsoft SQL Server 2016.pdf

(7734 KB) Pobierz
Introducing
Microsoft
SQL Server 2016
Stacia Varga, Denny Cherry, Joseph D’Antoni
Mission-Critical Applications, Deeper Insights,
Hyperscale Cloud
Introducing Microsoft
SQL Server 2016
Mission-Critical Applications,
Deeper Insights,Hyperscale
Cloud
Stacia Varga, Denny Cherry,
Joseph D’Antoni
PUBLISHED BY
Microsoft Press
A division of Microsoft Corporation
One Microsoft Way
Redmond, Washington 98052-6399
Copyright © 2016 by Microsoft Corporation
All rights reserved. No part of the contents of this book may be reproduced or transmitted in any
form or by any means without the written permission of the publisher.
ISBN: 978-1-5093-0195-9
Microsoft Press books are available through booksellers and distributors worldwide. If you need
support related to this book, email Microsoft Press Support at mspinput@microsoft.com. Please tell us
what you think of this book at http://aka.ms/tellpress.
This book is provided “as-is” and expresses the author’s views and opinions. The views, opinions and
information expressed in this book, including URL and other Internet website references, may change
without notice.
Some examples depicted herein are provided for illustration only and are fictitious. No real association
or connection is intended or should be inferred.
Microsoft and the trademarks listed at http://www.microsoft.com on the “Trademarks” webpage are
trademarks of the Microsoft group of companies. All other marks are property of their respective
owners.
Acquisitions and Development Editor:
Devon Musgrave
Project Editor:
John Pierce
Editorial Production:
Flyingspress
Cover:
Twist Creative
Seattle
Visit us today at
microsoftpressstore.com
• Hundreds of titles available
– Books, eBooks, and
online resources from industry experts
• Free U.S. shipping
• eBooks in multiple formats
– Read on your computer,
tablet, mobile device, or e-reader
• Print & eBook Best Value Packs
• eBook Deal of the Week
– Save
up to 60% on featured titles
• Newsletter and special offers
– Be the first to hear about new
releases, specials, and more
• Register your book
– Get
additional benefits
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
iii Contents

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin