title: Which is better: Bookmark/Key Lookup or Index Seek
body: <p>I know that an index <strong>seek</strong> is better than an index <strong>scan</strong>, but which is preferable in SQL Server explain plans: Index seek or Key Lookup (Bookmark in SQL Server 2000)?</p>
  
  <p>Please tell me they didn't change the name again for SQL Server 2008...</p>