Now that we have looked at the theory behind the storage of memory-optimized tables, we want to get to the real fun and create some of these objects.
Creating memory-optimized tables and indexes
by William Durkin, Milos Radivojevic, Dejan Sarka
SQL Server 2017 Developer's Guide
- Title Page
- Copyright and Credits
- Dedication
- Packt Upsell
- Contributors
- Preface
- Introduction to SQL Server 2017
- Review of SQL Server Features for Developers
- SQL Server Tools
- Transact-SQL and Database Engine Enhancements
- New and enhanced functions and expressions
- Enhanced DML and DDL statements
- New query hints
- Adaptive query processing in SQL Server 2017
- Summary
- JSON Support in SQL Server
- Stretch Database
- Stretch DB architecture
- Limitations of using Stretch Database
- Use cases for Stretch Database
- Enabling Stretch Database
- Querying stretch databases
- SQL Server Stretch Database pricing
- Stretch DB management and troubleshooting
- Summary
- Temporal Tables
- What is temporal data?
- System-versioned temporal tables in SQL Server 2017
- How temporal tables work in SQL Server 2017
- Creating temporal tables
- Altering temporal tables
- Dropping temporal tables
- Data manipulation in temporal tables
- Querying temporal data in SQL Server 2017
- Performance and storage considerations with temporal tables
- Temporal tables with memory-optimized tables
- What is missing in SQL Server 2017?
- Summary
- Tightening Security
- Query Store
- Why Query Store?
- What is Query Store?
- Query Store architecture
- Enabling and configuring Query Store
- Disabling and cleaning Query Store
- Query Store in action
- Query Store reports in SQL Server Management Studio
- Automatic tuning in SQL Server 2017
- Capturing waits by Query Store in SQL Server 2017
- Query Store use cases
- Summary
- Columnstore Indexes
- Introducing SQL Server In-Memory OLTP
- In-Memory OLTP Improvements in SQL Server 2017
- Supporting R in SQL Server
- Data Exploration and Predictive Modeling with R
- Introducing Python
- Graph Database
- Containers and SQL on Linux
- Other Books You May Enjoy
Creating memory-optimized tables and indexes
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.