I agree with the majority on this discussion. This is a SQL forum, and the "SQL" response to this question is "The Operating System Maximum". 256 is the answer to...

To quote this question, and the article it refers to:

INERSECT returns "those distinct values that are common between tables"

I have never seen a situation where:

SELECT DISTINCT a.x

FROM a

INNER JOIN...

Perhaps we are at cross purposes Hugo, I meant tht the result set is the same, regardless of uniqueness. Of course if the values are not unique then there's a...

Nice question, thanks.

Prior to answering I would have done something like

SELECT DISTINCT x AS 'Intersect Chars with BIGINT'

FROM #A

INNER JOIN #B on #b.M = #a.x

A quick execution plan shows...

I've been caught out on the QotD before by not reading the question properly, but I agree that the SQL being different to the actual quesiton seemed a little overly...

I would second that, as the first BOL quote says, a primary key IS created as clustered by default. There's just the "unless there's an additional unique constraint declared as...

I agree with the previous posts. A little more justification for the answer please.

Also, I'm sure that I've seen my execution plans change

WHERE colA IN(1)

into

WHERE colA=1

and

WHERE colA IN(1,2,3)

into

WHERE...

Thanks sknox for some good explanations here. To check I've got this straight ...

The internal casts give us 10 decimal places.

That effectively boils down to:

SELECT ( 1.6757400000 / 10000.0000000000)...

Tao Klerks (12/2/2009)

---

Right - but even if SQL Server was not doing any update at all (if there were no rows in the table, or if the WHERE clause excluded...

Appolgies for bumping an old post, but I too am looking for useful SSRS books (2008 and 2005 versions). David, do you recommend Teo's book? Did you find any good...

Yep .. that's exactly what I thought 🙂

mohaiv (9/8/2009)

---

I don't belive it...

The server can use index when the first part of the index is in the where clause.

I try it and MS SQL server realy use index...

Good question.

I also answered "1" as I mistakenly thought that it wouldn't scan the index, however it is obvious that the "flag" column isn't in the index so...

Every question's easy if you know the answer. I was surprised at this one, and got it right on the basis I knew one of my colleagues had got it...

Chris Harshman (8/20/2009)

---

I think the 30% of us (me included) that got it wrong just need to make sure we get our morning caffiene before trying to answer the questions...