With the understanding that I don't use either, the real question is, what are you trying to accomplish through all of this?  Why is the change necessary for you?

😀

Consider, perhaps, the utility of thing like BULK INSERT and BCP and even the ACE Drivers (which actually pale in comparison to the old JET drivers).

IIRC, you'll find no place where I've suggested doing such a thing in the article because there are much more effective methods to find gaps in a sequence of values. ...

@Carroll,

You said...

I import a table from a comma delimited file...

I'm curious as to what you're using to do the import of the file.

It's all been changed to "Must know how to create 7 Red Lines all perpendicular to each other".  If you don't understand the reference there then, especially as an "old...

Perfect... we disagree on a lot of things but we're still friends. 😀

Sorry.  They don't need to know anything about my systems.  Period.

On that note, I agree to disagree.  😀

From task manager under CPU

Sockets: 2

Virtual processors: 8

From Resource Monitor under CPU showing CPU0-CPU7 (only8). Same no 8 cpus from SQL Server Properties. The Max memory is 8gb.

From SQL...

Aye.  Thanks for...

As a bit of a sidebar, you may have some people come back with a suggestion of using the built-in STRING_SPLIT() function.  That will seem to work but there is...

Just a posting tip... if...

Processor: Intel(R) Xeon((R) CPU E5-2667 v3 @ 3.20GHZ ((2 processors)

Installed memory: 16 GB

64 bit Operating System, x64- based processor

SQL server Always on is configured on this with just 1...

If by MDP, you mean MAXDOP, I'd change it to 2.  You've got a fairly heavy load to be giving folks half the total CPU power for their queries.

If by...