I wouldn't mess with this. Uninstalling things from a cluster can be tricky, and I'm not sure it's worth messing with.

You don't want things enabled that you don't need, or...

You can see if it's enabled and check for jobs running, look in SSMS for publications defined.

With the rate of changes in some technology, even SQL Server, I feel like I've got 1 year of experience many times over in some areas (SSIS, Service Broker, etc).

Well, I'm definitely not a physicist. I took some Modern Physics, starting with relativity and moving forward from there, and was lost. We had some questions on the final...

Logins might be the big thing to move. sp_help_revlogin (search this site) can script out the logins so you can recreate them with the same passwords.

Script everything else out and...

You can, but you need to also be aware of logins. You can install SQL Server on the new box, attach the MDF/LDF as a new database, and you'll...

You can't make the FK reference multiple tables. It's a relationship between tables, not rows, so you can't switch on rows.

The way that I've done this is you have the...

Are you adding another database or an instance? Instances are more complicated.

Adding a database means that you share tempdb, and there are some threads, data cache, procedure cache, being used...

Given that information, there's no way we can help.

What is the load process? In SSIS, you could split things out, copying the record, in T-SQL, you could have a cross...

I had someone once tell me they wrote a VB4 app like this to page their manager every 10 minutes.

He didn't get the job.

It's somewhat clear, but we want to see that you've made an effort here. We don't do homework or exams.

Depending on the number of rows, you might also want to limit the batch size, meaning delete 1000 at a time.

Also, you're not freeing memory, you're freeing disk space.

Probably not an appropriate response, given that you'll affect lots of people besides the admin.

Ron, a good point. Project Management has a lot to do with things in all of these professions.

Not sure I'd call myself an engineer. Most days as a DBA I...

yes, mirroring does not eliminate the need for transaction log backups. You need to have those setup, possibly more often than once a day.