Steve Jones - SSC Editor (5/14/2016)
None, or negligible. This merely replaces the string being returned with some pattern.
That's what a lot of people surmised about the relatively new FORMAT function, which turns out to be 44 times slower than CONVERT.
Have you done or run across any actual "million row" performance testing? An admittedly too-quick search for such a thing is coming up fruitless.
Shifting gears a bit, I know a whole lot of people have been looking forward to data masking but I'm genuinely concerned because a whole lot of people are calling it a "Security Feature" and... it is [font="Arial Black"]NOT[/font]. It's a display feature that anyone with simple DBO privs can easily burn through. It must NOT be considered to be a replacement for any kind of real data security. If data must be protected, it must be properly encrypted with at least 1 salt, period.
is pronounced "ree-bar
" and is a "Modenism
" for R
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".
"Dear Lord... I'm a DBA so please give me patience because, if you give me strength, I'm going to need bail money too!"
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)