Viewing 13 posts - 1 through 13 (of 13 total)
The problem is that your WHERE clause says WHERE somePrimaryKe y = 3...
November 13, 2018 at 10:07 am
November 12, 2018 at 6:37 am
November 12, 2018 at 6:34 am
November 11, 2018 at 5:53 pm
November 11, 2018 at 3:15 pm
November 10, 2018 at 2:48 pm
November 10, 2018 at 10:28 am
November 10, 2018 at 10:26 am
November 9, 2018 at 8:26 pm
@Lynn Pettis
Although it has a unique constraint, otherwise...
November 9, 2018 at 2:59 pm
@Lynn Pettis
But I understand that the SQL engine...
November 9, 2018 at 1:49 pm
The MSDN says of OPTIONA (FAST X):
Specifies that the query is optimized for fast retrieval of the first number_rows. This is a nonnegative integer. After the first number_rows...
November 9, 2018 at 10:12 am
No, top in your case is not useful (and is likely detrimental processing-wise).
TOP 1 is evaluated after the entire query is processed. It does not short circuit the...
November 9, 2018 at 8:09 am
Viewing 13 posts - 1 through 13 (of 13 total)