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

Does your current hardware run well? If so, you have an idea of what's needed. For Dev, I'd try to get close to prod, maybe half (or quarter) size so...

tindog (4/27/2016)

---

I'd love to go to this, but have no SQL-y friends and get v anxious in unfamiliar places where I don't know anyone! (Never been to Liverpool)

I'll have to...

Excellent, say hi.

Like this: http://www.sqlservercentral.com/blogs/briankmcdonald/2010/11/05/sqlbigeek_1920_s-function-friday-_1320_-return-last-date-of-the-prior-month/

It's going to be a bit complex. Perhaps you can show some DDL and what you'd like?

If I have 3 fields, and 2 changes, do you want 2 fields returned...

Thanks, closing this for now.

bump

Is this function used elsewhere? In non-trigger code? If so, then I'd follow Kevin's advice. If not, I'd follow Hugo.

+1 to Hugo's thoughts, though I'd also note I want to be sure everyone (other sysadmins and developers) know the triggers exist. They are easy to forget about.

The new defaults in SQL 2016 are 1 per logical core, up to 8. I haven't typically worried about tempdb in many installs, but this seems like a small preventative...

As Kevin mentioned, this can be an issue.

One thing to shortcut is to calculate a hash across the row, and then only check UPDATED() if the hash is different. Again...