Gianluca Sartori (5/24/2010)

---

That page contains quite questionable statements. It's a shame it still comes in the first Google page for "sql short-circuit".

I'll...

Thanks Jeff, a bit of balance has been restored to The Force 🙂

The honest answer is: I have absolutely no idea, since...

WayneS (5/21/2010)

---

About 3 weeks ago, I was doing some research on a related topic and found that this answer is wrong. I had asked Steve to change this question then.

This...

Thanks, I'm glad you enjoyed them. There will be at least one more in this series.

I think...

Thank you.

If I may make the following observation: the Indexed View solution simply defers calculation from the SELECT query to the UPDATE/INSERT/DELETE queries that edit the...

Thanks Flo - I appreciate it.

My favourite SELECT without a FROM clause (sadly this does not draw pictures):

SELECT 'penguins'

WHERE 1 = 2

HAVING 0 < 1;

Known issue, which Microsoft have chosen not to fix for SQL Server 2005.

The problem is fixed in SQL Server 2008.

The workaround is to omit the RETURN statement or use GOTO...

CREATE TABLE dbo.Person

(

person_id ...

For the 2008 server, you...

Plagerizing the blog post about plagerizing. There is a moment when it is almost worth the irony to leave it there. Just a moment.

-- Kit

DECLARE @Param INTEGER;

SET @Param = NULL;

SELECT *

FROM master.dbo.spt_values V

WHERE (@Param IS NULL)

OR (V.number = 999)

OR...

clementhuge (5/21/2010)

---

I feel the article is actually pretty poor. All the dbas know this kind of dynamic sql. Someone suggested recompile and with (optimize) option and he is spot...

Agreed. Definitely time...