sknox (9/6/2012)

---

Hugo Kornelis (9/6/2012)

---

Rewriting them with APPLY makes them valid:

FROM Table1 AS t CROSS APPLY (correlated subquery) AS s ON s.Col1 = t.Col1

FROM Table1 AS t CROSS APPLY dbo.MyFunction(t.SomeColumn) AS...

Rich Weissler (9/6/2012)

---

In fact, when I pull up the actual query plan SQL used for this CROSS APPLY, it actually performs Nested Loops (Inner Join). I was also amused...

I'd put it differently. The only difference between CROSS APPLY and...

Good, solid question, Ron. And on a subject that probably can use a bit more propaganda; I think many SQL Server people still don't really know what APPLY is and...

Raghavendra Mudugal (9/5/2012)

---

L' Eomot Inversé (9/5/2012)

---

Nice question.

Raghavendra Mudugal (9/5/2012)

---

same as this http://www.sqlservercentral.com/Forums/FindPost1351393.aspx with little details change. Got a impression at first that this question was repeated before and then I...

bitbucket-25253 (8/31/2012)

---

sknox (8/31/2012)

---

Agreed. Also, if you haven't voted on the Connect submission for...

Striclty speaking, since there is no ORDER BY on the SELECT statement, these two...

g_one_2020 (8/30/2012)

---

Hi,

Sorry i tried, but failed to understand what u r saying...

I tried with the below query

CREATE TABLE #table1

(c1 INT, c2 INT)

INSERT INTO #table1 VALUES(1,2),(2,NULL),(3,2),(4,NULL),(5,3),(6,4)

select * from #table1 where c2<>2

As...

Thanks, Dugy!

Frankly, I am a bit disappointed that the site moderators included the number of correct answers. I had included a note that...

Gazareth (8/30/2012)

---

Nice question Hugo, thanks.

Got 3 of the 4 - knew bitmap indexes were available on other DB software, thought it might have been introduced with 2012.

Thought 260 columns for...

Thanks, Koen! (EDIT: And Braindonor, who added a reply while I was typing)

I submitted this question quite a long time ago - and I found that I had to spend...

Did you have the tables set up as described in the question text?

I've raised a documentation bug for this issue: https://connect.microsoft.com/SQLServer/feedback/details/759944/documentation-of-isdate-function-incorrect

@andrew: That part is not actually incorrect, but it is (in my opinion) badly phrased. I would personally prefer to use the...

An interesting question - especially because the correct answer (and it is correct, as can be easily proven by running the code) is not what the documentation predicts.

The documentation on...

Kenneth.Fisher (8/27/2012)

---

Understood. Where I'm not sure I agree with the design is the fact that if there is a table in the query that doesn't exist all other errors...