Primary Keys and Performance Level: Intermediate
In Paul’s top 10 most evil errors in SQL Server database development, number 2 is composite Primary Keys, and number 4 is Unwanted Bookmark Lookups. Both of these performance suckers are caused by poor Primary Key design. In this session Paul will explain how Primary Keys and clustered indexes affect performance and Situational Modeling - his proprietary method for designing Primary Keys.
Extreme Database Designs and the Queries that loved them Level: Advanced
You’ve heard that the EAV pattern is evil, you’ve heard that temporal database designs are impossible, and you’ve heard that the only way to model classes and objects in the database is to use an ORM like nHibernate or Entity Framework. But none of these myths are true and I’ll prove it with working design and code. In this session we’ll take SQL Server beyond the typical flat relational design to mind altering states including:
· how to properly model object-oriented inheritance
· how to code an EAV pattern with data integrity and ease of data query, insert, and update.
If you’ve become slightly bored with the relational model; if there’s no challenge to database design; if you long to break free from the flat 2-D relational designs, then this session will be like a breath of fresh air.
Paul Nielsen is a 7x SQL Server MVP, former author of the Wiley SQL Server Bible series, and the one behind the SQL Server MVP Deep Dives collaboration book. One of the old guys, he’s been designed and developing database since the early 80s (DEC Basic, Z80 assembler, AN/UYK-7 assembler, dBASE II CP/M, DataFlex, xBase, Access, VB/Pioneer SQL, SQL Server 6.5, 7, 2K, 2005, 2008, SQL Azure) . After three decades of mostly consulting, speaking, and writing, Paul now spends all his waking time on a software startup and bounces between T-SQL, SQL Azure, C#, WPF, and MVVM (plus finance, marketing, and usability testing) hourly. He lives in Colorado Springs with his 30 inch monitor, beautiful wife, and 3 kids.