Home Forums Article Discussions Article Discussions by Author Discuss content posted by Peter Samson Index Seeks, Scans, and Lookups RE: Index Seeks, Scans, and Lookups
akljfhnlaflkj
SSC Guru
Points: 76202
More actions
May 18, 2016 at 6:48 am
#1879820
Edward Boyle-478467 (3/1/2010)I think you may need u.database_id = db_id() in the Where Clause
Edward Boyle-478467 (3/1/2010)
I tried it both ways and the results were the same, for me anyway.