OK, had to look it up. Got confused about smalldatetime.

I've run into this before so was not surprised.

Thanks for the question.

Thanks for the question.

A little ahead of me. We're not there yet.

Learned more about DBCC today.

Thanks for the question.

Good selection of tricky answers.

Yep, you have to be careful with joins that you know exactly the kinds of connections you can get.

An easy one, now that I have learned the difference between UNION and UNION ALL.

Dalkeith (6/12/2015)

---

I almost never rename objects for older legacy systems - I mainly have tinges of regret over object names in these cases.

I am certainly more thoughtful now about how...

Thanks for the question.

I knew it would error with some kind of overflow error but I don't have all the error codes memorized.

Easy one for me, thanks.

It looked like something from my high school math class but I had to look it up