I want some Moore

Blog about stuff and things and stuff. Mostly about SQL server and .Net
posts - 219, comments - 2287, trackbacks - 33

My Links

Advertisement

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 also speak at local user group meetings and conferences like SQLBits and NT Conference
Welcome to my blog.
SQL Server MVP

My Books

SQL Server MVP Deep Dives 2
The Red Gate Guide to SQL Server Team based Development Free e-book

My Blog Feed via Email
Follow MladenPrajdic on Twitter


Users Online: who's online

Article Categories

Archives

Post Categories

Cool software

Other Blogs

Other stuff

SQL stuff

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 | Filed Under [ SQL Server ]

Feedback

Gravatar

# 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
Gravatar

# 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
Gravatar

# re: IsNull vs Coalesce Speed test

I wonder why my link to Adam's test got deleted.
12/2/2004 8:25 PM | Tara
Gravatar

# re: IsNull vs Coalesce Speed test

Nevermind. I see I posted it in the actual article.
12/2/2004 8:26 PM | Tara
Gravatar

# re: IsNull vs Coalesce Speed test

thanx tara...
12/2/2004 8:39 PM | Mladen
Gravatar

# 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
Gravatar

# re: IsNull vs Coalesce Speed test

thanks..
4/10/2008 10:50 AM | samples
Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET