Boost your SQL Performance by using the new features of SQL Server 2014
Deze cursus is momenteel niet ingepland op de open kalender, maar kan op aanvraag georganiseerd worden.Cursus aanvragen
SQL server 2014 contains several new Transact-SQL-statements and functions that allow developers to write more efficient code. We give an overview with several examples of how to use these statements.
The new in-memory database capabilities offer the possibility to boost performance of applications by extending the bufferpool, by using memory-optimized tables, and by using column-store indexes. Finally we will explain the usage in performance-metrics of a number of new dynamic views.
- New transact SQL statements and functions
- New transact SQL statements
- New functions
- In memory database capabilities
- The Buffer Pool extension
- Columnstore indexes
- Memory Optimized tables
- New and Enhanced Dynamic Management Views