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...

When you have a process that reads a lot of data, like your ETL, this will flush pages out of memory to hold the reads. As ETL ends, and "normal"...

I'd agree with John.

Fill Factor 0 is the same as 100. If you see lots of page splits, or an increasing amount, then I might lower this, but...

Roads  mostly ok here, though there's a turn on an uphill that constantly gets drifting snow. After I got home, my wife called to say she was stuck there. Towed...

Edit the article, attach the new script. I think you can remove the old one in the editor, but if not, ping the webmaster with the title of the article...