Interesting... thanks, Glenn.

Be careful when testing.  In this case, the OP hasn't defined what he means by "Assume I'm going to insert lots of data".  Does that mean for just one, multi-row...

Assume I have a table with a clustered datetime-index. Assume I'm going to insert lots of data. The data to be inserted is not in any specific order. Would...

This isn't the right way to do things.  You can easily get to the point of where your system is doing nothing but rollbacks.  You could also be causing grave...

Exactly.  I summarize that as being "Confidently Incorrect" and, in that area, ChatGPT...

@jonathan-2,

While the AI is quite capable of explaining exactly WHAT the code does programmatically, it's simply not capable of figuring out the WHY for most code.  For example, the AI...

From what I have seen the people I would regard as being at the top of their profession have certain traits.

• Competence with confidence
• Natural teachers.  If feels like...

Not aimed at the author but aimed at the whole concept...  Let's look at the first example prompt in the article...

You are an SQL Server database developer. Assume you...

Heh... let's look at the first paragraph in the article...

It's a good idea to learn more about different technologies. I've been amazed throughout my career, and even now as...

Not enough info... we're just guessing from descriptions.  Please see the article at the 2nd link in my signature line below for what to post for these types of performance...

Possible solution to the original question...

Given the original example data...

Create Table #Payments (ID int, Comment Text)

INSERT INTO #payments values (1, '65607 Processed via? DISC Last 4 digits...

In this case I would start splitting the comment based on a space.

check "Tally OH! An Improved SQL 8K “CSV Splitter” Function"

and process the spliter results...

• This reply was modified 2 years, 3 months ago by Jeff Moden.

Phil Parkin will tell you that I'm not a big fan of SSIS or most of the any other 4 letter words in SQL Server.

That not withstanding and with the...

Rule number 1: Claims of efficiency and/or performance MUST be accompanied by demonstrable code to prove it.

Third, the clustered index does store data in physical order on pages. The pagse/extents could get out of order, which is fragmentation, but that doesn't change the physical nature...