Thank you but the question above is basically just a...

If you moving data between SQL Servers, the "native" mode of BCP will...

we can use sp_spaceused to know how many space reservred by a table and know how many spaces for data space and index space, but if there is a ...

Just to be sure... the CTE's that generate the sequence in the code are NOT "recursive" CTEs.  They're "cascading" CTE's and there's a huge difference in both performance and resource...

Thanks Jeff & Scott for taking the time to reply. It may sound like a dumb question but I asked anyway because the hardware/network folks keeping trying to say...

To answer your question, my answer would be "Probably even more so".

Thank you Jeff Moden for you kind help!

you said "Understanding that there are at least 6 different Insert/Update patterns and the 4 of them are seriously affected by "ExpAnsive"...

+1 Million, Mr. Poole.  Especially on that last thing.  It's funny how people will change the tools (sometimes causing huge amounts of lost learning and functionality) in attempt to improve...

I think the 3 most important things are...

1. Correctly designed and indexed DRI.
2. Proper design of tables.
3. A serious understanding of page splits and all that goes with them including...

The ability to deploy faster has done nothing for the quality of code, IMHO.  I know you didn't say that in your good article but seem to be leaning a...

You're welcome and thank you for the feedback.

My first question would be, why are you using FLOAT to begin with?

This will use an index seek but the problem is for it to work I need to use substring or a left to get the rest of the start...

I can't speak for others but I find that anything that relies on log files for replication is a huge PITA, especially when it comes time to doing index maintenance.

If I concatenate the varchar columns into a single column, I will (almost) duplicate the table size. That don’t look so good either and I don't like this idea...