Realdolmen Education

Details

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

Aantal dagen

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