by andrew novick | Sep 20, 2016 | Past Events, Presentations, SQL coding, SQL Performance
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...
by andrew novick | Sep 19, 2016 | Past Events, Presentations, SQL coding, Uncategorized
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...
by andrew novick | Apr 21, 2015 | Past Events, Presentations, SQL Performance, Uncategorized
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...
by andrew novick | Sep 6, 2014 | Past Events, Presentations, User Groups
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...
by andrew novick | Aug 31, 2014 | Past Events, Presentations, SQL Performance, Talks and Seminars, Videos, Webinars
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:...
