Sean is correct in that you need some way of ordering things so that you know what table you are getting data from. Since you're trying to ensure all data...

My reminder is set.

Do we have a draft order?

Koen Verbeeck (8/11/2014)

---

GilaMonster (8/11/2014)

---

Maybe a throttle on posting new threads. A human can't post multiple threads in a...

First advice, don't chase the money. It will lead you to jobs that you might not otherwise like. The higher you go in salary/rate, the fewer jobs you have, and...

Our Stairway series can help with T-SQL. We have a couple on that subject.

Books are good, and the one Jason recommended (recipes) is a format I like. Those are good...

I'm not looking to break backwards compatibility. I just want improvements and things fixed that don't work well. There's no shortage of those. In replication, tooling has barely advanced, and...

Robert.Sterbal (8/11/2014)

---

More data might not get you the specific price on a house, but it will often help get you the reasonable estimate of whether a house should sell for...

My apologies. I forgot to check the other box and was traveling.

I've awarded back points.

Sean Lange (8/7/2014)

---

Well off for vacation for a few days to Colorado Springs. Will be nice to be in cooler air for a few days. See you all next week...

That makes sense. Text encryption/decryption is expensive. Working with numbers is much easier and gives much, much less of a hit.

Akki, does this help you?

A quick break for me, climbing a 14,000 foot peak in CO with the family.

The insert query needs to call the encryptbykey function with the appropriate parameters.

Depending on how you do this with SSIS, there are different ways, but essentially you need to open...

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