SQL Server 2014 – Articles (Hekaton)


 
–> Download & Install [SQL Server 2014]

–> New sample database [AdventureWorks 2014] for SQL Server 2014

–> [Developer Edition] is now free for Development & Testing

–> SQL Server 2014 Certification Update for [Exam 70-461]
 

–> New Features:

    – New Features in SQL Server 2014

    – Memory Optimized/In-Memory (Hekaton) tables

    – Behind the scenes with Memory Optimized Tables & Native Compiled SPs

    – XTP with In-memory Tables & Native Compiled SPs

    – Memory Optimized Indexes | Hash vs Range Indexes

    – Memory Optimized “Table Variables”
 

–> Enhancements:

    – Enhancements to ColumnStore Indexes
 

My YouTube Videos on SQL Server 2014:


Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.