Viewing 6 posts - 1 through 6 (of 6 total)
It's better to insert PII data as encrypted using whatever component or mechanism, regardless of where it is stored. Secured server or not. These days, there definitely isn't...
January 6, 2015 at 5:50 am
TheSQLGuru (9/2/2008)
Richard Fryar (9/2/2008)
Check for an insert trigger.I've seen ridiculously inefficient triggers resulting in high CPU and IO.
That is indeed a good one, Richard, and one that is often simply...
September 16, 2009 at 7:36 pm
Jeff Moden (9/14/2009)
Roy Oliver (9/14/2009)
Jeff Moden (9/12/2009)
Roy Oliver (9/12/2009)
Interesting... it'd be easier if SQL Server implemented triggers in the same way Oracle did.
Why? They are inherently RBAR. "For...
September 15, 2009 at 7:29 am
Jeff Moden (9/12/2009)
Roy Oliver (9/12/2009)
Interesting... it'd be easier if SQL Server implemented triggers in the same way Oracle did.Why? They are inherently RBAR. "For Each Row".
True, yet isn't...
September 14, 2009 at 8:18 am
Interesting... it'd be easier if SQL Server implemented triggers in the same way Oracle did.
September 12, 2009 at 3:52 pm
Viewing 6 posts - 1 through 6 (of 6 total)