Yes :blush:

The answer is that this should result in 1. The "SET @bit +=...

Plenty of people are saying the same thing: poor question, wrong answer (the right answer isn't even one of the available options).

None of those indices can be created on that...

UMG Developer (3/29/2011)

---

Tom.Thomson (3/29/2011)

---

If ARITHABORT is ON and ANSI WARNINGS off, arithmetic overlow causes the batch to be aborted. See the second sentence of the remarks section of this BoL...

smartin108 (3/26/2011)

---

I say P-O-2 is more efficient because the number of maximum string size handled by each level of REPLACE is usually greater than in the 65, 33... series:

N=1 (REPLACE...

Good question. I got it wrong, so I learnt something.

And of course spotted another apparent contradiction in Bol: according to the Bol page for the bit type[/URL] bit is...

Saint Petersburg; or maybe Tabourine Man; or both (this red stuff is confusing me - must stop pause drinking it).

Stefan Krzywicki (3/29/2011)

---

Yeah, I'd think at least at first an on-camera buffer of at least the size of an hour's filming would be needed, then you can upload to the...

GilaMonster (3/29/2011)

---

jcrawf02 (3/29/2011)

---

So, just had a thought, trying to figure out if it's a good one or not. Camcorder that records 1080p straight to the cloud? Unlimited (assuming unlimited pocketbook)...

Last time I looked at physics four kinds of elementary...

sknox (1/20/2011)

---

mike_walsh (1/18/2011)

---

This is quite possibly one of the best technical articles for a wide audience that I have read in a long time, Paul. To anyone who is already...

DIAMONDS

rmechaber (3/28/2011)

---

Tom Thomson: it would be interesting if you still have access to those databases to poke around and see what kind of results you get. You may find...

vikram.gharge (3/29/2011)

---

SQL Server 2008 brought us some new date types including DATETIME2 (which appears better in every way than DATETIME). But what happens if you run the following script (it...

Christian Buettner-167247 (3/28/2011)

---

Tom.Thomson (3/27/2011)

---

One comment though: depending on settings of ARITHABORT and ANSI WARNINGS, it is quite possible that none of the answer options will result, because the batch is...

Jan Van der Eecken (3/23/2011)

---

Craig Farrell (3/23/2011)

---

Jack Corbett (3/23/2011)

---

I'm not going to make the duck tour, but I am planning on getting into Boston somehow for the dinner. I...