Questions tagged [coalesce]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
103 votes
8 answers

Does SQL Server read all of a COALESCE function even if the first argument is not NULL?

I'm using a T-SQL COALESCE function where the first argument will not be null on about 95% of the times it is ran. If the first argument is NULL, the second argument is quite a lengthy process: ...
Curtis's user avatar
  • 1,255
2 votes
1 answer

Full outer joins, coalescing, indexes and views

I have two tables, let's call them TableA and TableB. TableA TableB ------ ------ ID ID Date Date Foo Bar Both tables ...
Shaul Behr's user avatar
  • 2,913