And just one more before anyone else suggests it:

-- Query 10

SELECT *

FROM [Product]

WHERE NOT([Name] <> @Name AND @Name IS NOT NULL)

the where clause above is actually logically identical to: WHERE ([Name] = @Name OR @Name IS NULL)

Gives the same full table scan as the other queries.