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
#1768044
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.
Richard Fryar (9/2/2008)
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
#1054782
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.
Roy Oliver (9/12/2009)
Why? They are inherently RBAR. "For...
September 15, 2009 at 7:29 am
#1053755
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".
Why? They are inherently RBAR. "For Each Row".
True, yet isn't...
September 14, 2009 at 8:18 am
#1053235
Interesting... it'd be easier if SQL Server implemented triggers in the same way Oracle did.
September 12, 2009 at 3:52 pm
#1052741
Easy Read. Very Clean.
Thanks.
December 5, 2008 at 8:06 am
#908332