Part 2 compares two ways to remove key lookup and remove RID lookup: a covering non-clustered index versus an index with included columns.
SQL SERVER – Query Optimization – Remove Bookmark Lookup – Remove RID Lookup – Remove Key Lookup
A quick tip to remove bookmark lookup, RID lookup or key lookup: why it happens when a query needs columns missing from the non-clustered index.
SQL SERVER – Interesting Observation – Query Hint – FORCE ORDER
A junior developer used the FORCE ORDER query hint without knowing what it does. Here is how it works and how much this one hint can change performance.
SQLAuthority News – Community TechDays in Ahmedabad – A Successful Event – Oct 3, 2009
Community TechDays in Ahmedabad on Oct 3, 2009 was a big success, with over 300 attendees across the day and a strong line-up of speakers. My event report.
SQL SERVER – Choose Right Edition of SQL Server Express for Your Application
Which edition of SQL Server Express is right for your application? A quick guide to Advanced Services, With Tools and Runtime Only, with download sizes.
Rotating the TDE Certificate
Rotating the TDE certificate protects recovery only when the new private key is backed up and old backups still restore.
Filtered Indexes and Where They Help
Filtered indexes help SQL Server target active rows in a larger table; learn useful predicates, parameter limitations, and how to verify plan choices.