Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,001 through 3,015 (of 59,067 total)

Reply To: The "Numbers" or "Tally" Table: What it is and how it replaces a loop

Stelios wrote:
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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 8, 2022 at 1:53 pm

#4073929
Reply To: How to Format Dates in SQL Server (Hint: Don’t Use FORMAT!)
Theo Ekelmans wrote:
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, 10 months ago by Jeff Moden.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
August 8, 2022 at 1:38 pm

#4073926
Reply To: How to Format Dates in SQL Server (Hint: Don’t Use FORMAT!)

@ 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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 8, 2022 at 6:05 am

#4073751
Reply To: How to Format Dates in SQL Server (Hint: Don’t Use FORMAT!)

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 8, 2022 at 6:01 am

#4073750
Reply To: SSIS Rows per Batch and Max Insert Commit Size

Jeffrey Williams wrote:
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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 8, 2022 at 1:04 am

#4073703
Reply To: How to Format Dates in SQL Server (Hint: Don’t Use FORMAT!)

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 7, 2022 at 3:22 am

#4073551
Reply To: How to Format Dates in SQL Server (Hint: Don’t Use FORMAT!)

SQLOzzie wrote:
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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 7, 2022 at 3:13 am

#4073550
Reply To: How to Format Dates in SQL Server (Hint: Don’t Use FORMAT!)

tboos wrote:
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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 7, 2022 at 2:55 am

#4073549
Reply To: How to Format Dates in SQL Server (Hint: Don’t Use FORMAT!)
henn wrote:
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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
August 7, 2022 at 2:42 am

#4073547
Reply To: Migration of 2008 db to 2016 db causing varchar(max) issues

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 7, 2022 at 12:22 am

#4073529
Reply To: SSIS Rows per Batch and Max Insert Commit Size

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 6, 2022 at 10:40 pm

#4073518
Reply To: SQL and Feature Flag Use in Software Development

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 6, 2022 at 6:32 pm

#4073486
Reply To: sys.object

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 6, 2022 at 6:24 pm

#4073481
Reply To: when check directory at shared path remotely it display not exist (false) althou

ahmed_elbarbary.2010 wrote:
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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 6, 2022 at 5:39 pm

#4073469
Reply To: when check directory at shared path remotely it display not exist (false) althou

Aren't you missing a backslash at the end of the declaration for the @ExportPath?
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 6, 2022 at 6:08 am

#4073238

Viewing 15 posts - 3,001 through 3,015 (of 59,067 total)