I'm assuming you're going to get the same performance hit as executing the deletes individually and wrapping them in a transaction. It should have the same effect on the transaction...

You mentioned running this as a job every week. If that's the case, you're better off doing this with command-line options/commands such as xcopy... You typically don't want to use...

As opposed to trying to do all of this through SQL Server, I would suggest scripting it using Perl, VBScript, or PowerShell. VBScript would be my last choice because it...

swjohnson (11/8/2007)

---

I don't believe much in certifications but prefer the school of experience and the only way to do that is to be like Nike--just do it! I was...

Kevin Sehl (11/9/2007)

---

Have to look at it from a positive point of view. If you ask the CIO if having the database(s) down for hours because Betty jean in...

What I was thinking of is if there was a database that was being used actively on the old system but hadn't been migrated to the new system. In those...

A user who maps in as dbo isn't restricted in any way within that database. Permissions don't apply.

A user who is a member of the db_owner fixed database role can...

I see. I only did the encryption by symmetric key. I didn't encrypt the symmetric key with an asymmetric key. Having view definition on the asymmetric key apparently isn't enough...

I was lucky in that regard in that I was started on ANSI JOIN syntax. I have come to appreciate the change required because a lot of the ways we...

Were all the databases that existed on the old system migrated to the new system?

It's a common word on the security side. If you ever end up taking a security related test, even Security+, you'll see it a ton. I saw it several times...

Remember, that the highest you're going to get for any quarter is ~ 90 days (3 months x 30...

I believe granting just VIEW DEFINITION on the symmetric key is sufficient for it to be used. You should then by able to revoke CONTROL.

Take full backups of all databases and make sure SQL Server verifies them. Probably wouldn't hurt to script the logins as well:

How to transfer the logins and the passwords between...

Professional SQL Server 2005 Administration

I've seen some folks recommend this one, too:

Administrator's Guide to SQL Server 2005

They do not just cover T-SQL, though.