Realdolmen Education

Details

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

This course is currently not scheduled on the open calendar, but can be organized on request.

Request Course

Duration

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.

Contents

  • 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