Which is faster coalesce or isnull

As a matter of fact, hold that thought. New post coming soon. I have seen coalesce give incorrect results on SQL when used on a binary datatype. Too right Paul, they do behave differently.

When passing the result of a query coalesce value, 0 in which the record is null to a SqlReader, reader. GetBoolean reports the cast as invalid. IsNull value, 0 behaves correctly though. Pavel: Interesting test case, and one I can repro on this end. Total time jumps from 1. There are probably a lot of other things that are going to greatly overshadow any gain or loss.

Had another go at it. What I wanted to achieve 1. I think it makes sense to test this even further. We may find a more significant difference. Active Oldest Votes. I think this blog post by Adam Machanic is most accurate in the performance benchmarking done on this topic, where the bottom line is Improve this answer. My Vote goes for "Is it worth it? I'd suggest there are probably bigger areas to optimise" truely said. Sarfraz Sarfraz k 70 70 gold badges silver badges bronze badges.

Prahalad Gaggar This only addresses the question as it was asked. I just ran a test on my own db. About k rows. Buttle Butkus Buttle Butkus 8, 13 13 gold badges 74 74 silver badges bronze badges. Fraser hmmm, true. Please see docs. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password.

Post as a guest Name. Email Required, but never shown. But read the article, it's a good read. Login using GitHub Register. Ask a Question. Please log in or register to add a comment. Please log in or register to answer this question. I think this blog post by Adam Machanic is most accurate in the performance benchmarking done on this topic, where the bottom line is Related questions.