It’s a religious war: should you define relationships or constraints in the database? What performance difference does it make, good or bad? In this lecture, you’ll learn why telling SQL Server about your data can lead to better execution plans, but worse deletes/updates on cascades. Demo scripts: Transact-SQL /* Mastering Index Tuning – Foreign Keys…
3.4 Foreign Key and Check Constraints
It’s a religious war: should you define relationships or constraints in the database? What performance difference does it make, good or bad? In this lecture, you’ll learn why telling SQL Server about your data can lead to better execution plans, but worse deletes/updates on cascades. Demo scripts: Transact-SQL /* Mastering Index Tuning - Foreign Keys...
To access this incredible, amazing content, you gotta get Live Class Season Pass or Mastering Index Tuning, or log in if you already shelled out the cash.
- 0.1 Prerequisites Before the Class (~4 hours)
- 1.2 The D.E.A.T.H. Method: Dedupe and Eliminate
- 1.3 D.E. Tools and Their Weaknesses
- 1.4 Lab 1 Setup: Dedupe and Eliminate
- 1.4b Lab 1: Dedupe and Eliminate – Brent Does It
- 1.5 The D.E.A.T.H. Method: Tuning Indexes for Specific Queries
- 1.6 Lab 2 Setup: Tuning Indexes for Specific Queries
- 1.7 Lab 2: Tuning Indexes for Specific Queries – Brent Does It
- 2.1 Adding Indexes with the DMVs
- 2.2 Tuning to Avoid Key Lookups and Residual Predicates
- 2.3 Lab 3 Setup: Adding Indexes with Clippy and the DMVs
- 2.3b Lab 3: Adding Indexes with Clippy and the DMVs – Brent Does It
- 2.4 Tuning Indexes to Avoid Blocking
- 2.5 Lab 4 Setup: Solving Blocking with Indexes
- 2.6 Lab 4: Solving Blocking with Indexes – Brent Does It
- 3.1 The D.E.A.T.H. Method – Heaps and Clustered Indexes
- 3.2 Filtered Indexes, Indexed Views, and Computed Columns
- 3.3 Lab 5 Setup: Leveraging Artisanal Indexes
- 3.3b Lab 5: Leveraging Artisanal Indexes – Brent Does It
- 3.5 Tips from the Index Sommelier
- 3.6 Lab 6 Setup and Final Lessons
- 3.7 Lab 6: Doing the D.E.A.
- 3.8 Lab 6: Tuning Indexes for Specific Queries
- About the Lab Exercises
- Bonus: Storytelling Time