corey lawson (5/9/2012)
We should all try not to be too dogmatic about things. Even CURSORs and cross-joins have their uses, after all (and not everything tastes better with tabasco sauce on it).
Who's being dogmatic here? I saw an article that was praising some RegEx SQLLRs and thought that might be a good thing but also saw nothing of comparative performance tests.
As many others have stated, there are many things to consider when considering which tools to use and I know that very well because I've been burned by the best of them! Instead of getting lectured (yet again, I may add!) on that fact that there are indeed other things to consider other than performance, can't you Regex folks just meet my simple request to do some broad spectrum million row performance tests so people don't get burned?
It's what any self respecting vendor, author, or endorser would do.
--Jeff Moden
Change is inevitable... Change for the better is not.