Jeff, when done right, natively compiled stored procedure achieve incredible performance gains. They are compiled software (DLLs), much like C++ code. The problem is that there are many limitations and...

I found an alternative to my specific problem. I used the identity to also sort the data and had another column that I could use to sort the data. I...

Unfortunately, sequences are also not allowed. That was actually my very first option.

Truncate statement is not supported for memory optimized tables.

Reseeding of memory optimized tables are not supported; that is, DBCC CHECKIDENT ('mytable', RESEED, 0) is not supported for memory optimized table whether done inside or outside of a natively...

Thanks everyone. I actually solved the problem by creating a memory-optimized table storing the ASCII table and querying it inside the natively-compiled stored procedure. I can add additional fields to...

I actually didn't think of the tally table which will speed up performance, no doubt. My problem is that I need to identify all the non-printable characters and replace them...