Thanks for the question, though I find it interesting that BOL has conflicting information.

Nice question, I knew it wasn't as simple as I first thought, and while I chose the correct answer I didn't want it to be correct. 😉

Nice question, thanks!

Tom.Thomson (7/22/2010)

---

Mike C (7/22/2010)

---

set transaction isolation level serializable

begin tran

create table #T (a int check (a=1) default (1), b int check (b=2) default(2))

insert #T (TABLOCKX) values (1,2)

select T.a+T.b as c from...

Nice question, thanks! I like the questions that bring up new features to help keep us up to date even if we might not have had the chance to upgrade...

Interesting article, and even more interesting discussion, thanks everyone!

Interesting question, and discussion, I seem to recall a similar question not too long ago...

I'm less worried about the points, though who doesn't like to have more points? 😉

What I am more worried about is that people who answer the question and get it...

I'm...

The other thing that comes to mind is that is an incomplete statement. It doesn't say what it will use more resources than.

* Using a persisted computed column instead: It...

This is a nice question but I have to disagree with your answer. Actually just one part of it: "Will definitely use more resources." which I can't believe is true....

Thanks for this article, it helped remind me of a step I need to make sure is in place for our next SQL Server upgrade.

Nice question, thanks!

I am a little curious what the "none" options was meant to be. (Or did you just want two choices, and forgot to delete the default third choice...

Trey Staker (7/19/2010)

---

I've read the complaints about coallation. I always assume default out of the box coallation for QOD but you all have a point since many of you...

Yeah, but not on your "Question of the Day" score. 😉