Bad Designs Have Consequences

Bad Designs Have Consequences

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.