Thom is absolutely right.  Having your reporting requirement dictate your database structure is like the tail wagging the dog.  Keep your database in proper normal form, and handle the pretty...

Yes, of course.  I...

I think I'd leave most of those questions until after an offer is made - maybe ask to speak to a techie (not necessarily one of your interviewers) if you're...

Or if you have administrator (or sufficient) permission on the server, you can open the actual text files that the logs are stored in (errorlog, errorlog.1 etc).

John

Set the tempdb data and log files to the size they need to be.  That'll be the size they've grown to, so don't shrink them.  Don't create extra log files...

I agree with RandomEvent.  Do you have any control over the query?  The two things I would consider are as follows:
(1) Don't stage in #CathodicProtection unless doing so provides...

Looks like the execution policy at the remote computer is too restrictive for your script to be run.  Did you follow the link given in the error message?

John

Yes, fair enough.  But nobody's going to do your homework for you, especially if you don't provide any evidence that you've at least put some effort in.

You've posted...

Copied and pasted straight from your coursework assignment!  Show us what you've tried so far, and we'll guide you further.

John

As Gail said, there's no easy way of doing that.  I would recommend that you restore your backup alongside the existing destination database and then do some ETL to get...

I'm not sure what you actually mean, although I suspect that the answer is going to be no.  Please will you describe your exact scenario, and we'll see whether we...

Use Ola Hallengren's solution.  Thousands already do, so it's very robust.

John

I'm pleased that works for you - but you're right, it's much better to know how to use it properly.  It's less typing, for a start!  I think the issue...