Explore real-world examples of unusual and problematic database designs in this 52-minute conference talk from the PASS Data Community Summit. Discover the consequences of poor design choices through a series of anonymized case studies drawn from 15 years of SQL experience. Learn about entity value attributes, lookup table issues, string handling problems, many-to-many relationship challenges, bit filtering pitfalls, and data type misuse. Gain valuable insights into common design mistakes and their impact on database performance and functionality.
Overview
Syllabus
Intro
Introduction
Entity Value Attributes
Lookup Tables
No Lookup Tables
No Strings
Many to Many
Bit Filtering
Data Types
Taught by
PASS Data Community Summit
