Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,651 through 4,665 (of 59,069 total)

Reply To: SPIDs not terminating

Only based on history, I've seen a lot of times where someone swears nothing was changed with anything having to do with the front end only to find out later...
--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 13, 2021 at 1:18 pm

#3929099
Reply To: Generate Monthly Transactions between Start and End Dates

Wouldn't it have been nice if MS had made the "datepart" of all these temporal functions so they could have take a variable? Lordy.
I do like that code, Jonathan.
--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 13, 2021 at 4:14 am

#3928979
Reply To: GetNumsAB

Nicely done, Alan. Your code runs faster than GetNums and fnTally because it only uses 2 CROSS JOINs instead of 31 and 3 respectively. It also doesn't have the habit...
--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 13, 2021 at 3:24 am

#3928970
Reply To: Backup has stopped working

I know this sounds a bit stupid but I can't see what you see. My first check would be to see if the "missing" databases actually exist any more. My...
--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 7:08 pm

#3928930
Reply To: Recursion Queries with a stored procedure?

The answer to your question is most likely "YES" but you've not provided enough information to go any further than that. Please see the first link in my signature line...
--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 6:04 pm

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

Viewing 15 posts - 4,651 through 4,665 (of 59,069 total)