Thanks for the question, Tom. I appreciate that this wasn't some "trick" question. I appreciate the straight-forwardness of it.

stephen.long 56048 (5/5/2014)

---

The list shown here includes bit in the list of "exact numeric types".

http://msdn.microsoft.com/en-us/library/ms187752.aspx (Data Types (Transact-SQL))

The definition of bit, shown here, calls it "An integer data...

george sibbald (5/2/2014)

---

paul.knibbs (5/2/2014)

---

Is it? I can't recall a situation where I've actually used this facility, although I knew the correct...

+1

To be honest, not quite sure how this wound up in the forums... I was posting a reply to the QOTD from Wed. 4/24.

I do not have an actual use...

+1

Thanks for the question.

Almost got it wrong when I read this from SQL Authority, Pinal Dave: "They can be used on Views only if they are persisted views."

-...

Great question. I did not get to finish my lunch, either.

Before I called you & interrupted your lunch, however, I would have reviewed what the error was (from the...

Richard Warr (3/19/2014)

---

If you didn't know anything about replication you'd say that the first option was pretty much the same as the last one so you'd select option 2.

If you...

+1

I remember being...

Thanks for the reply, Toreador.

Equivalent to:

SELECT X AS 'Intersecting'

FROM A

JOIN b ON b.y = a.x;

Except the ordering. INTERSECT returns the values in numeric...

I also got it wrong because I looked at the Total Points standings, where anyone above 10,000 points is listed as SSChampion. To me, this isn't a big deal,...

Primo Dang (8/15/2013)

---

Knut Boehnert (8/15/2013)

---

MikeSpike (8/15/2013)

---

But why is the result (0, 1) eliminated?

Does the engine first pick cp.pkey=0 from row 1 and 2 then looks at row 3-4 to check...