poor coding quality. My...

I'm going to disagree on #4. That might be preferable for some of you, but that's not the question or the point. It doesn't rename the file, it replaces the...

You're answering the question according to your requirements, not the question's. The question asked about renaming the file, not adding a new one.

Sorry, 2008 R2 build list: http://www.sqlservercentral.com/articles/SQL+Server+2008+R2/70092/

You should be on a particular branch of patching. The GDRs are usually for someone that is patched with the normal branching. If you look through the build list, you...

I suspect Aaron used that in testing. For audits, I typically wouldn't have normal users able to read the audit records. INSERT only, with SELECT given to admins/security staff.

Didn't need it in my testing. Just INSERT and I could have a normal user insert via DDL trigger.

GRANT INSERT ON dbo.DBSchema_Change_Log TO PUBLIC
GRANT CONNECT TO guest


This is the easiest way. I am , in general, not a fan...

It's possible, but you won't have the cluster up during a period of migration. The rolling migration will move the active node elsewhere, and then you upgrade in place. Then...

I would argue that this sentence, "What should I do to rename this file?", means adding a new file is incorrect.

I didn't add the verbiage for offline/online, or...

It would be good to see what you've tried here, and also, what are you calling frequency here? What is the math you're using.

This doesn't assume that data is of a certain quality. In fact, many people that analyze data assume data is broken, which is why any analysis work, ML based or...