Hmmm.....

Interesting article Jeff!

For the life of me, i would never have considered the impact of Format on out larger OLTP loads.

Knowing you being rather thorough, one question question was...

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

@ Frederico - Thank you for the links.  I've not yet read through them all but that first one is sure interesting.

@ Phil - Thanks for the proof reading.  I...

That's not a bad idea, Ryan.  It would be better, I think to name things like DATEFORMAT_MM/DD/YYYY but, of course, the won't work in the name without brackets.

The real issue...

To the specific question - yes, setting a commit size and batch size will reduce the impact on the transaction log and allow the log to be truncated.  Whether...

ratbak, Frederico, and Jeffrey... the same goes for you guys.  You always get involved and you always try to make a difference.  Thank you for your valuable/though provoking observations, discussion,...

Along the same lines, what techniques do people use to inject commas into, say, @@ROWCOUNT vs the FORMAT statement - FORMAT( @@ROWCOUNT ), '###,###,###,##0' ) AS RowCount

I still find...

MS needs to improve the performance of the Format command - a Convert(101) makes NO sense when reviewing code for date formatting problems - unlike the format which is...

FORMAT versus CONVERT

• There is no need (or rare need) to use formating date2string in high volume/performance cases on database layer. Real word conversions will be done on business...

I've not looked at the code behind the scenes but I suspect it copies one row at a time using 1 Insert/Values statement per row and that  would take almost...

So, you're doing a wholesale replacement of all the rows in the target tables every night?

If that's so, why not create a second database that's in the SIMPLE recovery model...

Thanks, palak231.  No pun intended but Feature Flags seem like a useful "feature". 😀  I really appreciate the link... I've not been in the "Development" world for more than 2...

Most definitely YES.  It could be just about anywhere including living on a WebServer, etc, etc, or in another stored proc as a bit of dynamic SQL where dependencies won't...

I don't use Python and  I don't have 2019, so I can't...

Aren't you missing a backslash at the end of the declaration for the @ExportPath?

Is there a problem with the code you posted?  I've not spent a lot of time looking at the code but I think you need to change the " =...