In most cases, when you tune an existing database, it’ll already have clustered indexes. However, we need to talk about what happens when it doesn’t: should you design a clustered index for it, or leave it as a heap? This lecture & demos explains the problems with wide clustering keys, show why IDENTITY fields are...
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.