Jeff Moden

Forum Replies Created

Viewing 15 posts - 946 through 960 (of 59,082 total)

Reply To: Recovery Point Objective (RPO)

Steve Jones - SSC Editor wrote:
12am full to 2am diff is 26 hours for the first one, so no, not 24 hours.
In terms of your last question, changing logins makes changes in master. Changing...
--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)

November 20, 2023 at 9:48 pm

#4331344
Reply To: How to Efficiently Find and Remove Duplicates in a Large SQL Database?

As a bit o a sidebar, I've found that the cutover point between DELETES and COPY to a new table is actually about (depending on the table, of course) only...
--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)

November 20, 2023 at 9:43 pm

#4331342
Reply To: Scheduling SQL Agent Jobs on Alternating Weeks

Hadn't thought about that. Thanks, Scott.
--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)

November 20, 2023 at 7:55 pm

#4331281
Reply To: SQL Window Functions Series: RANK() and DENSE_RANK()

Looks like they fixed 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)

November 20, 2023 at 7:42 pm

#4331276
Reply To: How to Efficiently Find and Remove Duplicates in a Large SQL Database?

Jonathan AC Roberts wrote:
Jeff Moden wrote:
Heh... pretty typical for things like this. The OP asks a question and then never participates in their own thread. While some great code has been posted, there...
--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)

November 20, 2023 at 7:41 pm

#4331269
Reply To: Recovery Point Objective (RPO)

lan2022nguyen wrote:
Jeff Moden wrote:
Mostly but, personally, I wouldn't tolerate an RPO of 24 hours for any important data. Why are these databases in the SIMPLE Recovery Model?
these are read-only dbs. there's...
--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)

November 20, 2023 at 4:29 pm

#4331171
Reply To: How to Efficiently Find and Remove Duplicates in a Large SQL Database?

Heh... pretty typical for things like this. The OP asks a question and then never participates in their own thread. While some great code has been posted, there are still...
--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)

November 20, 2023 at 4:03 pm

#4331168
Reply To: Replacing last few characters with another value.

Tava wrote:
Jeff Moden wrote:
Although there is a solution provided to the OP that works, I have to ask what the original reason is for trying to build a string based GUID...
--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)

November 20, 2023 at 4:30 am

#4330818
Reply To: Scheduling SQL Agent Jobs on Alternating Weeks

ildjarn.is.dead wrote:
The worst schema I had to implement: A customer wanted us to reboot the server for patches on the first friday of the month around 1am.
How do you schedule...
--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)

November 20, 2023 at 1:53 am

#4330770
Reply To: Recovery Point Objective (RPO)

lan2022nguyen wrote:
Does the following backup strategy satisfy the RPO of 24 hours. these are SIMPLE recovery. no transaction
FULL every sunday at 12 am.
DIFF daily at 2am
Mostly but, personally, I wouldn'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)

November 19, 2023 at 10:16 pm

#4330708
Reply To: HTML on the published article is broken

Nikhil Bangad wrote:
Thank you Jeff,
I have been emailing them everyday since last week. Did not get any response, therefore started a thread here.
Any other email or person I can reach out...
--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)

November 19, 2023 at 10:04 pm

#4330707
Reply To: Replacing last few characters with another value.

Although there is a solution provided to the OP that works, I have to ask what the original reason is for trying to build a string based GUID base on...
--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)

November 19, 2023 at 9:53 pm

#4330706
Reply To: Table with high unused space

If the clustered index has an ever increasing key and the inserts are following that key, you won't get page splits. If, however, the inserts are followed by "ExpAnsive" Updates,...
--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)

November 19, 2023 at 9:40 pm

#4330705
Reply To: UPDATE query is running slow and is causing blocking

To be honest, you need to challenge their design... this table is a HISTORY table! Why are they updating a HISTORY table? It should be an INSERT ONLY table that...
--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)

November 19, 2023 at 9:31 pm

#4330704
Reply To: SQL Window Functions Series: RANK() and DENSE_RANK()

You need to send an email to webmaster@sqlservercentral.com to get this fixed.
--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)

November 19, 2023 at 9:18 pm

#4330680

Viewing 15 posts - 946 through 960 (of 59,082 total)