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(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
This is a great tip.
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