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 SELECT p.PostTypeId, COUNT(*) AS Posts FROM dbo.PostTypes...
To access this incredible, amazing content, you gotta get Live Class Season Pass, The Team Membership, Mastering Index Tuning, Level 3 Bundle (Live Classes, Lab VM Included) or Level 2 Bundle (Live Classes, No VM Included), or log in if you already shelled out the cash.