I want some Moore

Blog about stuff and things and stuff...
mostly about SQL server and .Net

posts - 161, comments - 1491, trackbacks - 33

My Links

SQLTeam.com Links

News

Hi! My name is
Mladen Prajdić I'm from Slovenia and I'm currently working as a .Net (C#) and SQL Server developer. I'm also a MCP and MCTS for SQL Server.
Welcome to my blog.

Search this Blog

Users Online:

Article Categories

Post Categories

Cool software

Other Blogs

Other stuff

SQL stuff

<< First time | Home | spyware >>

IsNull vs Coalesce Speed test

in a forum i said i once did a test on isnull and coalesce speed test but i haven't documented it. so i did it again. results in articles under test ... :)

or here

Print | posted on Wednesday, November 24, 2004 9:39 PM

Feedback

# re: IsNull vs Coalesce Speed test

Isnull is faster:

http://blogs.x2line.com/al/archive/2004/03/01/189.aspx

11/24/2004 11:18 PM | Anatoly Lubarsky

# re: IsNull vs Coalesce Speed test

well try my code on your machine and tell me the results...
maybe the difference is in that you use it in the where and i used it in the select.
but i sure would like to know how the isnull works inside.

11/24/2004 11:23 PM | Mladen

# re: IsNull vs Coalesce Speed test

I wonder why my link to Adam's test got deleted.

12/2/2004 8:25 PM | Tara

# re: IsNull vs Coalesce Speed test

Nevermind. I see I posted it in the actual article.

12/2/2004 8:26 PM | Tara

# re: IsNull vs Coalesce Speed test

thanx tara...

12/2/2004 8:39 PM | Mladen

# re: IsNull vs Coalesce Speed test

I found IsNull() is the fastest option.

http://jerrytech.blogspot.com/2006/05/sql-2k-performance-isnull-vs-coalesce.html

5/24/2006 12:57 AM | Jerry Nixon

# re: IsNull vs Coalesce Speed test

thanks..

4/10/2008 10:50 AM | samples