Good One. Thank you for posting.

(well... this qtod very similar to example given under CONCAT function in BOL...)

Thank you for the question, good one.

(A week ago I installed the SSDT-BI with VS 2012, there I was looking in to the new projects and its little descriptions what...

(and If I recall correctly from my memory...) It applies for Serializable Isolation "only"

Good one, thank you for posting.

To be honest... never came across this message before, so I never tried adding 1 to the DATE type.

Msg 206, Level 16, State 2, Line...

Good one, thank you for posting.

(Or, the date '1931-02-29' if the year is not leap)

Good one, thank you for the post.

(even though knowing the answer accidently selected the wrong one and forgot the TOP clause)

Hugo Kornelis (5/31/2013)

---

I don't get it.

First, the idea of the question. We are given SQL to create and populate a table, *and* SQL that (supposedly?) shows the correct answers. Are...

Thank you for the post, bucket. Good one.

(:crying: not sure how I was suppose to calculate this whole in my head... so I executed the code and picked the answers...

Very Interesting, Steve. Thank you for posting.

I have read about filestream but never tried it practically. For testing this code, which came with good amount of learning and couple of...

Good one, Kapil, thank you for the post.

(I actually learnt this one of the previous/old Qtods where the computed col will change into regular col when the table used with...

call.copse (5/16/2013)

---

IgorMi (5/16/2013)

---

Hugo Kornelis (5/16/2013)

---

Raghavendra Mudugal (5/16/2013)

---

From BOL - "A table with a columnstore index cannot be updated" - seems likes the table will become as a look up table...

Good one, IgorMi, thank you for the posting.

COLUMNSTORE index is very new to me and didn't had a clue on what it does, so have to take the help of...

Hugo Kornelis (5/15/2013)

---

People...

That is cool... how did you set two questions back to back? (if it was just out of luck then it is a strange luck....)

@alex Fekken

I see what you mean... but in general if used... "pick a number between 1 and 100" and nobody goes "pick a number between 100 and 1"; I guess...