Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,986 through 3,000 (of 59,067 total)

Reply To: Retrieve records added across database (all user table) after a specific date

fafful wrote:
This is resolved. Thanks.
I'm really curious... how did you resolve this, please?
--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 11, 2022 at 3:41 am

#4075071
Reply To: Shrinking TempDb files or adding more files to TempDB?

To be honest, 500GB of TempDB is terribly large for most servers. You'd probably do well to find out the cause.
Whatever happens, don't do a shrink. It's a waste of...
--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 7:39 pm

#4074995
Reply To: Any way to scale MS Vulnerability Assessment Tool

It sounds like they're using the "Right click on the database in the object explorer" method.
--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 7:36 pm

#4074994
Reply To: Why transaction log cannot be trucnated during full backup

Jeffrey Williams wrote:
FWIW - I backup a 6TB+ database every night in less than 2 hours. That process backs up to a local drive - then copies the file to another...
--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 7:34 pm

#4074993
Reply To: CASE statement with multiple conditions (trimming & detecting spaces in between)

On the first item, I'm not grokking what the anomaly is that you speak of.
On the second, lookup the LEN() function and the SUBSTRING function.
--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 7:23 pm

#4074991
Reply To: Finding the row before the negative value

p.s. Since ID seems to be a sign of grouping, do you want this done by groups formed by ID or what? Is that why row 6 wasn't returned in...
--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:31 am

#4074618
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

Viewing 15 posts - 2,986 through 3,000 (of 59,067 total)