I thought it was weird that all but one of the answers was so small in size!:(

Toni-256719 (10/22/2014)

---

There is a typo in option #4 that caused me to get it wrong.

4) The Token Stream Definition parameters are TokenType, Status, CurrCmd,...

Gazareth (9/2/2014)

---

Hmm, not great to have a perfectly valid answer marked as wrong!

Nice to know you can add the persisted property without dropping though.

I wonder if there's any real difference...

have you checked the backup location for free space?

Have you checked anything already, for example, is there enough space in the backup location to store the backups?

I've just thought about it and updated the above. I missed out if someone was on holiday for the entire period that you want to search. I also change the...

I *think* the below will work, I haven't tested it but if not it shouldn't be far off (it's so close to the weekend :-D). I've guessed the Start and...

thotvedt (8/7/2014)

---

2. Being fairly new to performing complex (again, complex to me) T-SQL queries, what kind of language/syntax would I add to this join query to have it port it's...

I am by no means an expert, but from your explanation I'd suggest a simple SSIS package with data flow, which is called by a scheduled job.

I got it wrong by selecting the second correct answer.