Viewing 7 posts - 1 through 7 (of 7 total)
The advantage being proposed was the DNS alias, but we've since reasoned that using the IP in the alias and [Alias, Port] in the connection string would accomplish the same...
June 2, 2014 at 3:27 pm
True, but COUNT(NULL) and COUNT(1/NULL) are not mentioned in the T-SQL COUNT() reference. Since the results of SELECT (1/NULL) is NULL, this would appear to be a way to pass...
March 2, 2010 at 12:12 pm
SELECT (1/NULL) will return NULL. SELECT COUNT(1/NULL) will return 0. SELECT NULL will obviously return NULL, SELECT COUNT(NULL) will return an error. If this is documented anywhere in BOL, it...
March 2, 2010 at 10:38 am
dan.forest (3/2/2010)
I found that select count(*) and select count(1/NULL) both showed the same execution plan and took the same amount of time.Dan
Apparently they do, but they don't produce the same...
March 2, 2010 at 10:16 am
David.Poole (2/10/2010)
February 11, 2010 at 7:51 am
Malcolm Daughtree (2/10/2010)
February 11, 2010 at 7:18 am
I think there's some misunderstanding about what the TOP statement does (on the part of some readers, not the author). Unless TOP is used with a PERCENT value or an...
February 10, 2010 at 2:54 pm
Viewing 7 posts - 1 through 7 (of 7 total)