Category: Uncategorized

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 efficiently store temporal data that changes frequently.  EAV has its critics and the flexibility it provides creates… Continue reading

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 long as a series of… Continue reading

SQL Coding Tip – stored procedures

This is a great tip.

The Problem with User-Defined Functions (UDF) and a Solution

Download the sample script: Problem-Scalar-UDF-and-solution-andy-novick   and a PDF of the slides: The Problem with scalar UDFs and a solution – Andy Novick Or watch the video on Youtube:   User-Defined functions (UDF) have been around SQL Server since the 2000 version. They are a great way to… Continue reading