One last thing...BIN vs BIN2 collation? Does it matter?

Paul White (4/6/2010)

Worth doing, but the reason it is important here is that the sorting and comparison rules are very...

And another side note, that 8 sec for 12M rows using NVARCHAR(4000) and BIN collation turns into 36 seconds when using NVARCHAR(MAX) instead of NVARCHAR(4000). I know everyone said...

Wow, adding the bin collation really does affect performance greatly!

I just tried this over one of my tables that's got 12M rows and it went from 28 sec...

So, question about these splitter functions (which are pretty much the most used tools in my arsenal, btw!), are they faster/more efficient being run from the I.B.G. CTE tally table...

Pong

So...I'm liking the DelimitedSplit8K, but I need to increase it to an unknown number between 25K and 150K rows. Any way to modify this so I can go that...

BTW, this is explained a little more

EDIT:

HERE

(sorry, that was the wrong link)

HERE

(and again, they moved my link)

HERE[/url]