Not to hijack too much, but is the data highly distributed towards numbers or characters? Large fields of text?

Is the impact more in tempdb or the user db?

We have some articles that look at differences: http://www.sqlservercentral.com/search/?q=SQL+Server+2012&t=a&sort=relevance

2012 was a nice release. AlwaysOn, Extended Events (as Jason mentioned), Full-Text Search got enhanced, Service Broker, a few other things.

Is there...

I have a few friends with TDE enabled on large production databases (> 100GB) and fairly low overhead. Around 4-5% for their workload.

Overhead is workload dependent and can impact performance...

CDC works great, but it complicates administration, and especially DR. If you use it, make sure you understand how to restore it.

Jason Whitish (8/1/2014)

---

We're in the middle of a huge project that's migrating an old legacy database into the current model, and we're using this strategy heavily, along with instead of...

As Keith mentioned, there is no way to do this directly without having something setup. You can use a trigger and audit changes into another table (or the same one...

SQLRNNR (7/31/2014)

---

That's completely misworded. It's "because you had just two pina coladas."

Just dropped over to the Heap Consultancy and I see a comment from Bill in KC about me staring at him from the login banner and then this:

"Steve is cool"

Maybe...

Jeff Moden (7/30/2014)

---

Instead of a move to Ask.SSC, maybe a...

Eric M Russell (7/31/2014)

---

If the windows group like 'MyCorp\ProductionDBA' or 'Builtin\Administrators' are members of SYSADMIN, and user account 'MyCorp\JohnSmith' is added to one of these groups, then he has sysadmin...

Sure there is. A long running...

FYI, here's a post someone sent me: http://blogs.xtivia.com/home/-/blogs/alerting-on-elevation-of-privileges-in-sql-server?_33_redirect=http%3A%2F%2Fblogs.xtivia.com%2Fhome%3Fp_p_id%3D33%26p_p_lifecycle%3D0%26p_p_state%3Dnormal%26p_p_mode%3Dview%26p_p_col_id%3Dcolumn-2%26p_p_col_count%3D2%26p_r_p_564233524_categoryId%3D12100%26p_r_p_564233524_resetCur%3Dtrue

Lynn Pettis (7/30/2014)

---

It should be noted as well, that sometimes people come to SSC and ask question(s) and then actually get upset when we try to show them better ways...

Eric M Russell (7/30/2014)

---

SQL Server Audit has an 'Addlogin' event and a 'Add Login to Server Role' event. For example, when a login is created or granted membership in SYSADMIN...

jcrawf02 (7/29/2014)

---

[Been reading through Michael's lengthy post and comments, only to find yours Steve. I think his main problem is that SO is focused on *only* providing fish, where SSC...