Great QoTD! Thanks.

Two concepts were revisited at the same time.

Damn, I misunderstood the question.

I thought which of those options were actually true but not combined.

Either way I would have guessed wrong. 😀

Thanks for the question.

Learnt something new today.

If only we could use variables as object names in other places, my life with MSSQL would be a lot easier. 🙂

Thanks for the question.

I didn't get it right but then I'm not a human SQL parser. :w00t:

Very concise and informative. Thank you.

Sorry but this QotD was too confusing. 🙂

Nowhere does its author states that he has execution plan options enabled.

And an UPDATE command returns no resultset (unless we use the OUTPUT...

I would choose both first and last answers. 😀

Sorry, guys. That doesn't explain my problem well.

I made an example which is exactly what's happening.

I appreciate any help since we have an SLA deadline with our customer and I...

I chose the obvious answer and got it wrong.

That's very interesting to know.

I wonder how other DBMS's would behave...

I'm thinking of the Generate Scripts Wizard feature here.

Couldn't you do a smart replacing in a text editor to change the part of the index's name the mentions the table's...

I totally failed reading the "BETWEEN -1 AND -10" part.

Thank you, Hugo. Awesome question.

Rose Bud (4/18/2013)

---

Personally, I don't mind when the person who posted the question admits there is a gap in their understanding. I know the SSC community will fill it...

I knew it had to do with the batch but I ended up choosing "0" as in "the whole batch will fail". Stupid me. 😀

Interesting.

I thought that the second SET IDENTITY_INSERT would automatically set the TblA1 property off. But it actually gives an error.

SET IDENTITY_INSERT TblA1 ON;

GO

SET IDENTITY_INSERT TblA2 ON;

GO

I was kinda confused because...

It seems many people had the idea that FILESTREAM is a data type and not a column property.

Thanks...