TheSQLGuru (4/22/2010)

---

I too would like to see more information on exactly what is required for the optimizer to be able to translate APPLY to a JOIN so it can use...

Managing Long-Running Transactions

SOM

:blink:

Check the last definition: http://en.wikipedia.org/wiki/Morning_glory_(disambiguation)

:blink:

Hugo Kornelis (4/22/2010)

---

Thanks, vk-kirov. I was not aware of this operator.

From the limited information I could find on it, it will be used if the same data is used at...

Exactly. SQL Server is being improved all the time - and enhancing its ability to...

Why add the ISNULL? It isn't...

:laugh:

Stefan_G (4/21/2010)

---

Another thing to think about is this

SELECT CASE WHEN 0=0 THEN getdate() ELSE CAST('20100100' as datetime) END

SELECT CASE WHEN 1=0 THEN getdate() ELSE CAST('20100100' as datetime) END

The first statement...

Stefan_G (4/21/2010)

---

The bug is all about how a CASE statment with only constants is evaluated. For example: SELECT CASE WHEN 0=0 THEN getdate() ELSE dateadd(day, 1, '99991231') END

This code...

Stefan_G (4/21/2010)

---

The behavior is still exactly the same.

select * from dbo.SafeDateAdd('99991231',1) still generates an error.

Paul, are you really 100% sure that you can run this on your 2008 system without...

The evaluation order of CASE is documented here: CASE (Transact-SQL).

The expression in the ELSE part is not...

Stefan_G (4/21/2010)

---

Now we are getting somewhere! You have a newer version than I. My version is 10.0.1600.22 (X64). So, apparently Microsoft agrees with me. This was a bug...

Well this took off while I was asleep!

Stefan, I strongly disagree that changes in undocumented, implementation-specific behaviour amounts to a bug. Optimiser code can, and does, vary between versions,...

Hugo Kornelis (4/21/2010)

---

I never understand that habit. The semicolon is a statement terminator, not a statement starter, so the logical place for it is at the end of a statement,...