Polygon article Polygons SQL query gets executed, even though it wasn’t called from the context of the statement.
In this case, you’d be better off calling the query directly, like this: SELECT TOP(name) FROM Person WHERE name = ?
You can even query multiple columns by using the GROUP BY and GROUP BY NULL operator.
SQL Server 2016 has the option to query columns directly with the select statement, but this is a relatively slow process compared to querying rows.
In general, this is the direction that you want to go in if you want query speed.