Are you sure you're connecting to the same machine? Are you going with Windows name, IP, FQDN? I'd suspect you're connecting to two different machines somehow or two instances for...

That does seem high. Do you have some type of auditing turned on?

Interesting. I wonder if there is anything about the discounts being for students only. If so, I wouldn't expect you to get one.

Good luck on the exams, and watch for...

I'm not sure the SQL binaries come into play. It's separating the various spindles used in databases that give you performance boosts.

If tempdb is heavily used, then this can help...

I wasn't aware of this, do you have a URL where this is?

First of all you shouldn't shrink databases. It moves things around and causes fragmentation and can slow down index response and increase query times. Shrinking should only be done if...

You are there to make things better, drive the use and efficiency of SQL Server forward. Training someone to bring up the rear so when you're gone things still move...

tables, views, etc are NOT files. They are objects within a database file. You can have multiple database files per database, but those do not determine the tables, etc.

You script...

Like cut/paste, drag/drop?

Not yet. Thought you could file this as a "wanted enhancement" on Connect (connect.microsoft.com).

sqlSentry might help here. I know they can move jobs from one to another. Not...

I don't use devices ever.

I want separate files for every backup. If you have 2 or more backups on a single device or file and something happens, you could lose...

I'd go with the above advice. You could even schedule this to run only on selective tables, meaning only do tables that start with a-f on one day, g-m on...

If that doesn't work, do the shutdown. You can rename one file and the db will be suspect and then you can deal with things.

We've debated eliminating the prizes, but the way we've given them away, if we try to determine who's eligible and who's not it becomes an administrative issue. One that we...

You really need three scripts since they have to be run in different places.

The source does the backup or detach and needs to run on the source server.

The copy...

I'd do this, checking the script for things like security account.

You can right click in SSMS and script jobs.