Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,681 through 4,695 (of 59,089 total)

Reply To: Generate Monthly Transactions between Start and End Dates

rjjh78 wrote:
Hello,
I am looking for help to understand how to generate multiple rows based on Start and End Dates. What I have is customers enrolled into a monthly fee with...
--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)

September 12, 2021 at 5:31 pm

#3928923
Reply To: large table cleanup using Delete
Bruin wrote:
How about a Batch delete with batches to delete.
```
DECLARE @batch INT
SET @batch = 10000 /* SIZE OF BATCH */       ...
```
--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)
September 12, 2021 at 4:35 pm

#3928918
Reply To: Are the posted questions getting worse?

x wrote:
Jeff Moden wrote:
You have your own odel and that's fine. What I took exception to was your passive aggressive and highly judgemental mouth saying such condescending things like you being...
--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)

September 12, 2021 at 3:40 pm

#3928909
Reply To: large table cleanup using Delete

Bruin wrote:
RowCnt NullCnt 949718305 391584820
That means that you're trying to delete about 41% of your table.
DELETEs are fully logged even in the simple...
--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)

September 12, 2021 at 5:52 am

#3928870
Reply To: large table cleanup using Delete
Ok... the next step is for us to make a bit of an assessment. Please run the code (change the table name if it's not correct).
```
 SELECT...
```
--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)
September 10, 2021 at 6:13 pm

#3928671
Reply To: large table cleanup using Delete

Scratch my previous. The table you provided the code for has a NOT NULL for the attribute name but it does allow nulls for the attribute value. Why are you...
--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)

September 10, 2021 at 5:55 pm

#3928664
Reply To: large table cleanup using Delete

Bruin wrote:
Sorry did my Insert wrong should not contain the NULL string should be blank..
No... not blank... it should contain the word NULL without quotes. So go back and fix...
--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)

September 10, 2021 at 5:34 pm

#3928662
Reply To: Are the posted questions getting worse?

You have your own odel and that's fine. What I took exception to was your passive aggressive and highly judgemental mouth saying such condescending things like you being personalty embarrassed...
--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)

September 10, 2021 at 5:15 pm

#3928629
Reply To: Are the posted questions getting worse?

Steve Jones - SSC Editor wrote:
If you continue to view that image or title as discriminatory or exclusionary for white people, and that's the unintended consequence, I'm not sure if I can explain...
--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)

September 10, 2021 at 12:11 am

#3928409
Reply To: Are the posted questions getting worse?

Please don't take it upon yourself to be personally embarrassed for me. You've take everything I've stated and twisted it to mean the exact opposite of what I mean.
--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)

September 9, 2021 at 11:41 pm

#3928404
Reply To: Are the posted questions getting worse?

Steve Jones - SSC Editor wrote:
Is holding a conference focused on black/Latin groups discriminatory? I suppose it could be seen that way if it only allowed black or Latin attendees/speakers/etc. In the description 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)

September 9, 2021 at 8:52 pm

#3928366
Reply To: Are the posted questions getting worse?

Hugo Kornelis wrote:
You want to attack organizers of tech events that target women, people of colour, or other under-represented groups? Then better come prepared with strong arguments to convince the world...
--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)

September 9, 2021 at 1:50 pm

#3928224
Reply To: Are the posted questions getting worse?

Brandie Tarvin wrote:
Completely missing the point, Phil.
It's not discrimination. You are not being forbidden from attending these conferences. You are not incapable of getting jobs or networking because of your gender...
--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)

September 9, 2021 at 1:28 pm

#3928218
Reply To: Are the posted questions getting worse?

Greg Edwards-268690 wrote:
I view some events like in a bit different light. They serve as inspiration for others to see and believe they can be successful. I doubt many presenting 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)

September 9, 2021 at 8:00 am

#3928117
Reply To: Are the posted questions getting worse?

Can someone tell me why this isn't horribly racially prejudiced?
https://www.eventbrite.com/e/black-is-tech-conference-2021-tickets-149570987851
Can I open a "White Is Tech" conference without any ramifications? I never would, though. THAT would be racist.
Can you...
--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)

September 8, 2021 at 9:32 pm

#3928019

Viewing 15 posts - 4,681 through 4,695 (of 59,089 total)