Viewing 8 posts - 1 through 8 (of 8 total)
For anyone else who stumbles across this thread looking for answers, this blog post details the code to perform similar functionality.
July 30, 2017 at 10:39 pm
Seems like it's only installed in the GAC:
Microsoft.SqlServer.Management.IntegrationServices.dll assembly location
December 1, 2015 at 10:37 pm
Having come across this, as a follow up if anyone's interested in benchmark comparisons, here's an easy to read posting:
http://cc.davelozinski.com/sql/like-vs-substring-vs-leftright-vs-charindex
which shows the speed differences between LEFT, RIGHT, LIKE, SUBSTRING, and...
December 1, 2015 at 1:20 am
Did you read Matt Miller's comment a few posts above? Try making the query SARGable, re test and post the results.
With all due respect, anyone is just as capable of...
October 16, 2015 at 2:27 am
Matt Miller (#4) (10/15/2015)
ChrisM@Work (10/15/2015)
_watching (10/14/2015)
October 15, 2015 at 11:29 pm
If you're interested in updated speed comparisons on how fast each is (well, on SQL 2014 anyway), this ➡ LIKE vs SUBSTRING vs LEFT/RIGHT vs CHARINDEX article with benchmarks makes...
October 14, 2015 at 6:01 pm
If anyone was interested in speed comparisons, it seems CHARINDEX is a lot faster than LIKE and others. The benchmarks can be found here.
It's quite interesting because charindex seems to...
October 7, 2015 at 2:44 am
0 down vote
"Left" vs "Like" -- one should always use "Like" when possible where indexes are implemented because "Like" is not a function and therefore can utilize any indexes you...
July 6, 2014 at 11:09 pm
Viewing 8 posts - 1 through 8 (of 8 total)