Find queries waiting for memory allocation with sys.dm_exec_query_memory_grants, plus wait_order and the query plan, when you suspect memory is short.
SQL SERVER – Query Optimization – Remove Bookmark Lookup – Remove RID Lookup – Remove Key Lookup – Part 2
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.
geography Point: Latitude Comes Before Longitude
geography Point uses latitude, longitude and SRID arguments. Its coordinate order differs from POINT text, so inspect both returned properties.
Rotating the TDE Certificate
Rotating the TDE certificate protects recovery only when the new private key is backed up and old backups still restore.