Not only that, the passphrase will need to be in code, or be entered by people. How many people can keep a shared passphrase secret?

If you think about it, not...

You can grant the CREATE PROCEDURE permission to a role and the developers could do that. They wouldn't be able to create necessarily under the owner of DBO, but you...

There are a variety of ways to do this (cursor, while), etc. Depends on what you need to do, but Sp_msforeachtable works.

Do you mean IP addresses?

If you are moving SANs, I'm not sure that it should matter for the IPs. I would suggest you attach the servers to the new SAN...

Your parenthesis don't match, You have an extra open one, and you need to either remove it or determine where you're missing the closing one.

The CTE is part of the statement. Duplicate the CTE in both statements.

You can disable CPUs with the affinity mask, but MS doesn't recognize that. The other solution (besides removing a CPU) is to run a VM and allocate only one CPU...

Those are good articles. Profiler will work if you can limit how the developers access (meaning trace their logins).

Not sure that's a correlation. If the page file is growing, I'd make it larger to start with. Restarting SQL Server can clear things out and it changes access patterns...

I've run integrity checks daily, as mentioned above, before backups. Alert someone if you find errors.

For rebuilds, I've moved to procedures that look for fragmentation and rebuild those ones only....

truncate is one of those strange ones. I'd go with David's suggestion of Execute AS if you must do this.

As an FYI, I got a Kindle two weeks ago and have been blogging a bit on it. The latest is here, a two week review:http://blogs.sqlservercentral.com/steve_jones/archive/2008/09/12/kindle-the-two-week-followup.aspx

It's been awhile, so someone with more recent experience might need to explain this, but

a share is supposed to be a common copy. I think we used shares to...

Simon, you must not be married :w00t:

I never rejoined code, as an FYI. Stuff branched for a particular release and then remained there. Change were always on the main branch.

That fit that particular development cycle, but...