100 Times Faster: Experiences Making SQL Server Fly September 20, 2016 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 feature of SQL 2014, and they got close.  Inspired by that effort, this presentation looks at some recent cases where I’ve been able to achieve … Read More

Entity-Attribute-Value (EAV): The Antipattern to Great to Give Up September 19, 2016 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 efficiently store temporal data that changes frequently.  EAV has its critics and the flexibility it provides creates opportunities for abuse and introduction of bugs leading some to call … Read More

SQL Server In-Memory Tables April 21, 2015 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 long as a series of limitations can be observed.  This presentation describes what In-Memory tables are … Read More

SQL Server 2014 In-Memory Database (Hekaton) September 6, 2014 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 Developers
SQL Server In-Memory Tables (Hekaton)
Read More

Video – Improving SQL Server Performance by writing faster T-SQL Code- Sept 11, 2014 August 31, 2014 This webinar is now available for viewing online at any time. (About 60 Minutes)
Some of the concepts we will cover include:

Ways to find code that’s slow:

DMV’s like sys.dm_exec_procedure
SQL Profiler and Server Traces
Extended Events
Writing your own logging code. (My favorite but it’s a lot of work)


Why scalar and TVF functions are slow
Finding high use functions with … Read More