Heh... I have a much easier solution.  Use the DelimitedSplit8K function for this and not worry about stuff breaking. 😉

Just to be sure there is no mistake, I'm not the one calling this "Complete Lunacy".  I was citing what someone else said.

Stupid new forum software doesn't allow expansion of the graphic I posted... at least not for me.  Here's something a little larger that I copied from Excel to Word and...

To answer the original question... no... there is no OBVIOUS difference.  You have to look for it and then you'll find that there's a huge difference. 😉

First, here's...

Sure.  And understand that this is just my opinion.  If you want official definitions, look up each term on the Internet.

My Basic Definitions of the Terms

A...

See the BackupFile table in MSDB for the individual file sizes.

https://docs.microsoft.com/en-us/sql/relational-databases/system-tables/backupfile-transact-sql

My suggestion would be that, whatever you end up doing, it needs to be what you want to do.  Remember also that all roads in this business lead to the...

Dunno anymore.  I posted...

Neither.

If the desired table name is "Clients", then DO NOT create a table named "Clients".  Instead, create a VIEW called "Clients" and have two "staging" tables.  Call one...

I...