stakes (4/29/2016)

---

I recently did stress testing our new hardware, before we migrated our databases to it. I used Ditributed Replay to do the stress test (i.e. replay the workload from...

I like it. I'll open a ticket.

You certainly could take the SSN from the app and do a hash/map in another table. Use a salt, protect the tables with limited access and that can work. I...

It's still available in SQL 2016. My guess is it's not ever going away

The reason the procedure only exists in Enterprise is compression is an Enterprise only feature.

Looking forward to seeing you all at Nexus/Bits.

Notification icon where?

Eric M Russell (4/28/2016)

---

Steve Jones - SSC Editor (4/27/2016)

---

splitting hairs.

Losing the salt would be the equivalent of losing the symmetric key, if the domain is known. In the case of...

First, please format your code (spacing and use the code=sql shortcut to the left of the editor). Second, we don't have your environment, so if there are tables needed to...

typo corrected.

A couple things. First, use the code=plain code on the side to format your tables and use spacing so we can read things. Like this:

EmpID Date FieldName...

As Lynn noted, your query is incorrect. There are two different sets of columns in each SELECT. One column in the first, multiple ones in the second.

The format for substring...

splitting hairs.

Losing the salt would be the equivalent of losing the symmetric key, if the domain is known. In the case of a social security number/taxid, this is the case....

Sorry, mistake. Got tabs confused.

closing.

The cache drops old plans and add new ones as needed.

If you find certain items getting slow, I'd address those queries/procedures/functions themselves rather than clearing the cache. If you...

That's hard to read, and as Sean mentioned, it doesn't quite make sense. Please format your results as plain code (shortcut to the left of the edit box), so that...