Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,016 through 3,030 (of 59,086 total)

Reply To: Finding the row before the negative value

meryemkurs072 wrote:
Thank you.
Under normal conditions, when a row goes negative, the query lists the rows before that row.
However, if a movement has never been negative, it does not bring the...
--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 10, 2022 at 1:23 am

#4074617
Reply To: Help with Copying backup files and capture results in output file with details

I'm no help here but that "password in text" stuff is one of the reasons I hate it. 😀
--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 10, 2022 at 1:10 am

#4074616
Reply To: Consistent Time

Is that with our without Leap Seconds? 😀
--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 10, 2022 at 1:05 am

#4074615
Reply To: My Problem, or Yours?

I keep it real simple... I assume it's my problem until I can prove, usually with code or logs, that it isn't actually my problem. As the old saying goes,...
--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 10, 2022 at 12:55 am

#4074612
Reply To: Any BIxPress users out there?

Normally, when a company buys another company, like Solar Winds did, and the announce the discontinuation of a product that was owned by the company that was bought, they also...
--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:44 pm

#4074091
Reply To: Please recommend me a cloud service based on description

Quote removed... it actually had a spam link in it that I flat out missed.
Thanks for the heads up, Frederico.

--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 5:49 pm

#4074070
Reply To: Read multiple files of same name and process in DB

I guess I don't understand the issue here. Just load up all the files name for, say, the employee table and process them in date order. Then, move the processed...
--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 5:45 pm

#4074069
Reply To: Date vs Datetime recommendation

usererror wrote:
@jeff Moden,
I updated my queries and now there are no 1900 dates for where death date does not exist. I added a new bit of code to the ETL...
--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 3:38 pm

#4074004
Reply To: how to Make a copy of Full Recovery DB and Restore it to a Simple Recovery Db

Thanks for the feedback, Pat. It sounds like you've got things under control.
--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 2:00 pm

#4073930
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 4 years 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

Viewing 15 posts - 3,016 through 3,030 (of 59,086 total)