Normal 0 false false false EN-US ZH-CN X-NONE MicrosoftInternetExplorer4 ...

It’s well known that bookmark lookup (aka key lookup in case of a clustered index) is not cheap, especially when it comes to retrieving a lot of data. So I’m not going to rehash the pros and cons of bookmark lookup or why bookmark lookup is expensive. But I’ve noticed that when it comes to discussing bookmark lookup, all the literature seems ...

Next Thursday, May 8, the New England SQL Server Users Group will have a special meeting, featuring Craig Freedman from the SQL Server development team.  Craig is The Man when it comes to query optimizer internals, and wrote an incredibly detailed chapter on the topic for ''Inside SQL Server 2005: Query Tuning and Optimization''. At the ...