We’re rewarding the question askers & reputations are being recalculated! Read more.

Questions tagged [coalesce]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
100
votes
8answers
17k views

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: ...
2
votes
1answer
556 views

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 ...