Toreador (4/20/2010)
"SQL Server does not have an efficient way to retrieve rows based on a known value for PersonID."There have obviously been too many trick questions lately, as I thought this was one as well!
SQL Server does have an efficient way to retrieve rows based on a known value for PersonID, and here it is:
create index indPersonID on Persons (PersonID)
😉
This was my reasoning also. Just as the first part (duplicates) would require manual intervention to accomplish, so to would the implementation of SQL Server's efficient way to retrieve rows.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes