Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,976 through 6,990 (of 59,091 total)

Reply To: Date Join Issue

nymets86 wrote:
I cant provide anything specific to tables for sensitivity reasons but can explain in detail below.
TABLE1 has Y for Year and M for Month. It also is the main...
--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)

June 4, 2020 at 10:31 pm

#3760685
Reply To: Explanation of Page Splits

Ok... trying again as a ZIP file...
Edit... looks like that did it. Just double click on the link and an Explorer window should open up. Double click on the .ppsx...
Attachments:
You must be logged in to view attached files.
--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)

June 4, 2020 at 9:44 pm

#3760671
Reply To: Explanation of Page Splits

@stevec883 and anyone else interested...
I've extracted a section out of my "Black Arts" Index Maintenance #1 PowerPoint presentation and extracted it as a "slide show" so you don't actually need...
--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)

June 4, 2020 at 9:40 pm

#3760670
Reply To: DB Design/Normalization Question

Look for the [DOWNLOAD] button at the following link...
https://github.com/bssug/PresentationDownloads/blob/master/20190521_JEFF_MODEN_BLACK_ARTS_INDEX_MAINT_03.zip
I don't write PowerPoint "presentations"... rather, I write highly animated PowerPoint "Books". If you go into the "present" mode of 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)

June 4, 2020 at 8:30 pm

#3760660
Reply To: Explanation of Page Splits

stevec883 wrote:
Excellent thanks. This clarifies a lot and I look forward to those articles.
It sounds like, after reading both posts (Jeff and Brian), that inserting data in the middle 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)

June 4, 2020 at 8:17 pm

#3760658
Reply To: DB Design/Normalization Question

EsquireDeveloper wrote:
Quick Follow Up Question: The two sets of addresses and two sets of contact info for each applicant are obvious cues to normalize and create tables for each.
But everything...
--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)

June 4, 2020 at 7:39 pm

#3760644
Reply To: Index fill factor

Tom Uellner wrote:
Jeff Moden wrote:
Heh... there actually is a way. 😉 I've presented the method to just a couple of PASS chapters and I'm working on some proposed articles for a "Stairway".
Now,...
--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)

June 4, 2020 at 7:33 pm

#3760640
Reply To: Data moth wise

DATEDIFF(mm,0,[Date]) calculates the number of month boundaries crossed (in effect, returns a count of months) since day "0", which is the 1st of January, 1900. That means that each date...
--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)

June 4, 2020 at 5:25 pm

#3760583
Reply To: Explanation of Page Splits

Mr. Brian Gale wrote:
Fill factor only comes into play when the index is NEW or REBUILT. Basically, it is just telling SQL that the data is either changing frequently or the inserts...
--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)

June 4, 2020 at 4:36 pm

#3760573
Reply To: DB Design/Normalization Question

Heh... Most people have a rule of "Normalize 'til it hurts then denomalize 'til it works". I disagree with that. My rule of thumb is "Normalize 'til it hurts... then...
--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)

June 4, 2020 at 4:03 pm

#3760560
Reply To: Data moth wise

Thanks for the feedback and you're welcome. The key now is, since you're the one that has to support the code, do you understand how it works? Especially the DATEDIFF/DATEADD...
--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)

June 4, 2020 at 3:59 pm

#3760555
Reply To: Is it acceptable to use the presence of a value in a NULLable column as a flag?

Mr. Brian Gale wrote:
I think either are acceptable, but I think one will have better performance. I am pretty sure "NOT NULL" is not sargable so you may have a performance hit...
--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)

June 4, 2020 at 3:56 pm

#3760554
Reply To: Is it acceptable to use the presence of a value in a NULLable column as a flag?

Generally, I try to avoid all "IsPresent", "IsCurrent", "IsActive", and, for sure "IsInactive" and "IsNotCurrent" columns, etc, etc. The data tells it all.
--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)

June 4, 2020 at 3:32 pm

#3760543
Reply To: Data moth wise
Try this...
```
 SELECT  Name
        ,country
        ,avg_amount = AVG(amount)
    ...
```
--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)
June 4, 2020 at 3:30 pm

#3760539
Reply To: Data moth wise

Since your result set that shows what you want to display doesn't contain results that match with your sample data in the 3rd column, what are you looking for 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)

June 4, 2020 at 3:16 pm

#3760534

Viewing 15 posts - 6,976 through 6,990 (of 59,091 total)

Jeff Moden

Forum Replies Created

Attachments: