Thanks, and no worries.

Compression could still help you, but you'd have to have the clients do it if you move to standard edition. Not sure it's worth the effort there,...

Jeff Moden (5/4/2015)

---

I don't understand why anyone would need to do this through PowerShell. Can someone who actually had such a need please explain? I'm looking for someone...

I set the placeholder, but didn't commit.

I'm in.

Eric M Russell (5/5/2015)

---

In most scenarios the auditing operation should be done asynchonously, if possible, for performance reasons. But you can't do that if the auditing operation is bundled within...

arr.nagaraj (5/4/2015)

---

Guess I am that "someone" whose auditing requirements surprised you 😀

one of the needs for auditing to be async is, in most of the shops, the infrastructure...

I'm with Gail, somewhat on this. It's not that I think it's harder for me to restore or recover, but it is slightly less readable and confusing. That's the concern...

The explanation has been corrected. Thanks

David.Poole (5/3/2015)

---

The thing that was overlooked was that outsourced staff are just like us. They want to get their hands on the new toys. Would you accept a...

RonKyle (5/4/2015)

---

If you have EE, I tend to agree that moving stuff out of the Primary file group makes some sense. However, for most of the databases and instances, I'm...

sorry, too busy and didn't think of it. Anyone want to send me one for next year...

Take it, Shawn.

I think showing it a few ways would be good as it's likely a short one.

RonKyle (5/4/2015)

---

It makes the database a little more robust because isolating the system tables from the data tables and indexes reduces the chance that the...

jonathan.crawford (5/1/2015)

---

Jeff Moden (5/1/2015)

---

I had a rare and wonderful opportunity, today. Luis is in town and I finally got to meet him and have lunch with both him and...

Your question or post doesn't really have context or make sense.

Eric M Russell (5/1/2015)

---

Steve Jones - SSC Editor (5/1/2015)

---

david.gugg (5/1/2015)

---

We run a daily trace that captures SQL running longer that X seconds. This gives us a good idea of...