Boost your SQL Performance by using the new features of SQL Server 2014

Ce cours n'est actuellement pas prévu sur le calendrier ouvert, mais peuvent être organisé sur demande.

Demande de cours

Nombre de jours

1 day(s)

Audience

Prerequisites

Objectives

Methods

Instructor-led workshop

Description

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

Détails