Just to explain it to myself or visualize what's going on, I drew a tree of parts with assemblies etc. I started with something I could get my head...

Create specific logins as owners for the databases. Just as in the other question you asked, least privilege principle should always apply. Setting 'sa' as owner potentially opens things...

Had to take my non-calendar table solution down (previously posted in this spot).  It had an error when more than 1 month was spanned.

Without wanting to give away the answer, the script creates an empty table variable that it populates to generate a select.  So I would look at rewriting the...

Interesting.  Thanks, Steve and thanks again for posting your article.

p.s.  And because you've put forward a good effort, IMHO, PM me and I'll show you how to think about this to solve it.

I am not trying to 'game the system' I want to improve my understanding of cursor's. Any company can ask many different questions and will also change there questions....

I'll also add that if the original was taking 20 seconds, there's a very good chance that it needs a little rework to make it more performant and use fewer...

Hey Jeff.  Great idea!  I'm going to add this to my notes.

When you have a new historical period, you create a new table and modify the...

It's actually much simpler than even that but that's it on any clues on this thread.  Please PM the OP if anyone wants to help or discuss further.  Help protect...

p.s.  If you really want to do it right with Partitioned Views, create each period's FileGroup and File in a separate database using the exact same naming convention but with...

Actually, it's...

MVDBA is spot on but I'll add that you MUST backup to a different physical machine than where your database files live.  If backup compression is available, definitely use it...

Better than what Carey Hower just proposed, why not just leave the table named as HugeTable with no date marker and just back that up?  What they're doing is insane.

I...

To be honest, I'm totally opposed to publishing answers to interview questions that some company obviously feels important about.  Such answers would make it pretty easy for other people to...