Thanks for the question.

I'm actually surprised so many people have got this wrong.

I say that because when I started using CTEs I was not accostumed to using the semicolon so...

Good question, Steve.

I've been working with computed columns a lot these days as part of a change we're implementing.

+7!

Thanks for the question, Steve.

Very good function, btw.

Very easy one.

Have a good weekend everybody!

Good question.

+1.

As others, got to the answer using the elimination method 🙂

Raghavendra Mudugal (8/27/2014)

---

that word "query" is confusing... I guess he means in one "batch"...

I got it right.

I saw the "VARCHAR(30)" change in the question right off the bat, but the answers are all messed up. I just picked the two that I figured...

SQLRNNR (8/26/2014)

---

Nice question.

I like how it underscores the "It depends" with SArg-ability and why in the forums it really is good to have both DDL and execution plans when trying...

Very good question.

Thanks!

Can't believe I got that wrong.

Thanks for the question, though.

+1

Thanks

paul.knibbs (8/21/2014)

---

I thought the interesting part was that the actual "name" part of the table name *is* only 116 characters long--apparently, the # showing it's a temporary table is counted...

Good question.

Thanks.

Hany Helmy (8/6/2014)

---

Easy, another fast way (but maybe not the fastest), just highlight the table then press Alt + F1 will give you all table structure, definition, columns names, data...

In my case, I didn't know about the limit when using TABLOCK, so I learned something today.

Well, I don't feel so bad since 83% so far have been incorrect also...