Viewing 15 posts - 3,001 through 3,015 (of 59,067 total)
Thank you for all this.
Despite the knowledge I gained, the beauty of learning more effective ways is what keeps me going on.
I definitely agree with that. Thanks for stopping...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 8, 2022 at 1:53 pm
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...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 8, 2022 at 1:38 pm
@ 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...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 8, 2022 at 6:05 am
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...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 8, 2022 at 6:01 am
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...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 8, 2022 at 1:04 am
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,...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 7, 2022 at 3:22 am
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...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 7, 2022 at 3:13 am
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...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 7, 2022 at 2:55 am
FORMAT versus CONVERT
--Jeff Moden
Change is inevitable... Change for the better is not.
August 7, 2022 at 2:42 am
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...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 7, 2022 at 12:22 am
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...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 6, 2022 at 10:40 pm
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...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 6, 2022 at 6:32 pm
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...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 6, 2022 at 6:24 pm
i found issue
os.path.isdir() working local only
so use another thing working remote to check directory
so How to handle that
I don't use Python and I don't have 2019, so I can't...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 6, 2022 at 5:39 pm
Aren't you missing a backslash at the end of the declaration for the @ExportPath?
--Jeff Moden
Change is inevitable... Change for the better is not.
August 6, 2022 at 6:08 am
Viewing 15 posts - 3,001 through 3,015 (of 59,067 total)