Category : Key Lookups - SentryOne Team Blog

Category: Key Lookups

Resolving Key Lookup Deadlocks with Plan Explorer

Resolving Key Lookup Deadlocks with Plan Explorer

Greg Gonzalez (@SQLsensei) uses Plan Explorer to walk through troubleshooting a very common type of deadlock : updates conflicting with key lookups.

Is a RID Lookup faster than a Key Lookup?

For T-SQL Tuesday #78, Aaron Bertrand (@AaronBertrand) takes a look at whether RID Lookups are faster than Key Lookups, with a small battery of fairly simple duration tests.