Too funny.  A SPAM post was removed but the "Discussion" section still has the title with the SPAM info from the title still intact.  That's another item they'll need to...

Is the "SQL Server" you're testing on also on your laptop?

I can't help because I don't use PowerShell for much but I am curious.  The output file in your original post is "c:\fileloading\rmcstdetails.csv".  Where is the "c:\" drive physically located? ...

I remember when I was a young kid and listened to Walter Cronkite talk about the year 2000, which was decades away at the time.  Once again, it's decades away...

Since MS messed up with performance starting in 2019 and hasn't made it any better in 2022, I sadly pronounce that I Don't Believe Anymore but I keep Doing the...

I'm confused.  You're talking about Oracle but you're posting in an SQL Server 2019 forum.

Since I'm not privy to your previous attempts and have never used "CDATA", what is it...

I've seen several people say that.  I have to ask "Why"?  The statistics are stored in the database just like...

Just curious, Rod.  Did you  ever figure this out?

Between updates, just set the database to "Read Only".  As an alternative, you can create individual File Groups with one or more Files in each and set those File Groups...

I don't work with Powershell in most cases, which means I'm not very good with it.  GOOGLE seems to work for this though.

Try this link.

https://sqlstudies.com/2022/07/07/powershellbasics-expanding-the-column-width-to-avoid-truncation/

The following supposedly applies only when your database is in the BULK_LOGGED or SIMPLE Recovery Models.

There is a feature known as "Fast Inserts".  I wrote about that hot mess back...

BWAA-HAA-HAA!  This was more of a test of knowledge about Christmas songs than I thought it would be. 😀

Merry Christmas, Steve, and thank you for the early present of seeing you at the Pittsburgh SQL Saturday.  It was a real treat, my ol' friend.

Thank you kindly for the feedback, windchaser... especially after nearly 20 years!  I couldn't believe it.

You've answered you own question.  The tables are, in fact, NOT identical.  You different indexes, which can make the difference between a full table scan (or clustered index scan) and...