Jeff Moden

Forum Replies Created

Viewing 15 posts - 931 through 945 (of 59,063 total)

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
Reply To: HTML on the published article is broken

You need to send an email to webmaster@sqlservercentral.com to get this fixed more expeditiously because they don't typically monitor this particular forum and I'm pretty sure they don't have actual...
--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:16 pm

#4330679
Reply To: How to find second position after decimal

Steve Collins wrote:
Thank you Jeff. 44.9% or 31%? Either way there's no implicit type conversion 🙂
Ken McKelvey's solution in the "Pivot with grouping intervals" topic is interesting. It cross join's a...
--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:00 pm

#4330676
Reply To: How to find second position after decimal
Steve Collins wrote:
You could test if the modulo .1 of HRS equals zero
```
;WITH cte_data AS (
    SELECT CAST(50.10 AS numeric(5, 2)) AS HRS
  ...
```
--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 18, 2023 at 9:32 pm

#4330265
Reply To: How to find second position after decimal

Nearly duplicate post with an incorrect improvement calculation removed.
--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 18, 2023 at 9:31 pm

#4330264
Reply To: Can Data Save the World?

david.gugg wrote:
Very interesting to think of how differently this concept can be thought about 6 years later than it was originally published. Since then the fact that people use data...
--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 16, 2023 at 12:17 am

#4328488
Reply To: Time Tally Table
Jonathan AC Roberts wrote:
Try installing the table valued function here: https://www.sqlservercentral.com/scripts/a-daterange-table-valued-function
Then to select 15 minute intervals as in your example:
```
SELECT Value
  FROM dbo.DateRange('1900-01-01 00:00', '1900-01-01...
```
--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 16, 2023 at 12:12 am

#4328487
Reply To: estimated # of rows when modification count > 0

With all the automatic query tuning stuff they did in 2022, who knows how the optimizer estimates things now?
It'll be interesting if anyone shows up that actually knows.
--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 14, 2023 at 3:41 am

#4327050
Reply To: Unique Primary Key Linked to Multiple Accounts

yrstruly wrote:
It is joined on the Account numbers, which appears in the table multiple times. Problem is the Unique Primary Key is then mapped to these Account numbers multiple times.
So...
--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 14, 2023 at 2:52 am

#4327024
Reply To: Import ridiculously large CSV file

We "talked" on LinkedIn. I provided a link to "BULK INSERT" and introduced "BatchSize" and "Tablock" to you. You also found "Example f.", which is about how to do things...
--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 13, 2023 at 4:13 pm

#4326797

Viewing 15 posts - 931 through 945 (of 59,063 total)