Presentations
100 Times Faster: Experiences Making SQL Server Fly
Download the presentation: 100-times-faster-experiences-making-sql-server-fly-sql-saturday-prov-2015-12-12 How do you go about making a program run a lot faster! Like 100 times faster? It’s difficult. Microsoft tried in the Hekaton project, its in-memory tables…
Entity-Attribute-Value (EAV): The Antipattern to Great to Give Up
Download the presentation: entity-attribute-value-eav-the-antipattern-too-great-to-give-up-andy-novick The Entity-Attribute-Value (EAV) is a design pattern for relational databases that uses an extreme form of normalization to achieve flexibility and the ability to…
SQL Server In-Memory Tables
SQL Server In-Memory Tables(Hekaton) Andy Novick April 2015 SQL Server 2014 aimed to improve OLTP performance by adding In-Memory tables and native compilation of the stored procedures that use them. In-Memory tables bring incredible speed for the right workload so…
SQL Server 2014 In-Memory Database (Hekaton)
Join me as I discuss SQL Server 2014’s new In-Memory option for tables with the natively compiled stored procedures. This features allows up to 25 times the performance of traditional disk based tables for OLTP workloads. Presentation at the New England Microsoft…
Video – Improving SQL Server Performance by writing faster T-SQL Code- Sept 11, 2014
This webinar is now available for viewing online at any time. (About 60 Minutes) http://www.mssqltips.com/sql-server-video/332/proving-sql-server-performance-by-writing-faster-tsql-code/ Some of the concepts we will cover include: Ways to find code that’s slow: DMV’s…