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.

Please don't use the subject line for questions. Ask the question in the post.

Back up the model transaction log. I think you can start SQL Server in single user mode,...

No real risk, but I think you might need to grab a full backup when you change it back.

You have no choice there. If you need Agent to restart SQL Server, then you have to do that. However, the local services allow for a restart.

If you have major...

The data has to move, one way or the other. The thing you want to do is minimize things. So, is it less if the data moves to the report...

You don't need internal variables.

You might need to convert/cast to get to numerics and then do your math

select (cast(arrivetime as int)/60) 'Minutes'

Please don't repost full article text. It's a copyright violation. Link to it and quote if you'd like.

They are interesting articles.

Is there a question here?

Please read Books Online or research a little. There are lots of examples for triggers out there.

Replication deals with transactions. If there were an issue in the middle of the transaction, it would roll back. If it is committed, it's there.