Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,141 through 7,155 (of 59,102 total)

Reply To: User Forum is Terrible

@steve-2...
No... this is not like stack overflow especially not when it comes to publishing code nor in rendering previous published code (how hard would it be to overcome the quadruple...
--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)

May 13, 2020 at 12:34 pm

#3751120
Reply To: Are the posted questions getting worse?
x wrote:
jonathan.crawford wrote:
I feel like I'm missing something. An inner join is necessarily an existence check, why not:
```
SELECT u.UserId
  FROM UserTable u
  JOIN TableA 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)
May 13, 2020 at 12:23 pm

#3751110
Reply To: Lack Of User Options

You've yet to make the realization that the "upgrade" they did wasn't really user oriented, although I'm sure that Steve will argue with that. It was to increase the looks...
--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)

May 12, 2020 at 9:53 pm

#3750989
Reply To: Choosing Sequences Over Identity

jcelko212 32090 wrote:
>> In 99.9% of all cases, all most people need is an automatically assigned value incremented by 1. <<
No, I would say that in the majority of cases people...
--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)

May 12, 2020 at 9:47 pm

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

What percentage of the rows of each table are less than 12 months ago?

--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)

May 12, 2020 at 6:39 pm

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

Obviously, it's time for you to move this all to the cloud where you can easily add a bazillion CPU's to scale out for this horribly complex problem. After 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)

May 12, 2020 at 1:30 pm

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

It sounds to me like it's all the fault of the query and the person that wrote it... not an absence of indexes.
--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)

May 12, 2020 at 11:59 am

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

Michael L John wrote:
Why can a person not understand that when you write a query against dev that has 6 rows per table, and the query does 3 table scans, it will...
--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)

May 12, 2020 at 3:39 am

#3750650
Reply To: What does the Future DBA Do?

I'm working with a company that's at the beginning of a migration to the cloud and have been in close contact with the DBA at another company that's completed 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)

May 11, 2020 at 2:58 pm

#3750489
Reply To: Representing uncertainty in difficult times

I vote that this conversation end now. Unsubscribing. 😀
--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)

May 11, 2020 at 2:46 pm

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

Ed Wagner wrote:
Steve Jones - SSC Editor wrote:
I can't remember most days which day it is. Mostly because I think it doesn't matter and then I don't pay attention. I check the display in 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)

May 11, 2020 at 2:33 pm

#3750480
Reply To: Choosing Sequences Over Identity

jcelko212 32090 wrote:
I don't understand what a sequence has to do with an identity property. They are two very different things. Just look at all the optional clauses that you get...
--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)

May 11, 2020 at 1:37 pm

#3750435
Reply To: Update duplicate values to 0

jcelko212 32090 wrote:
When you set something to zero like this, you're changing the data,you're destroying the fact which Chris Date and I think most other RDBMS experts feel is a really...
--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)

May 11, 2020 at 12:45 pm

#3750402
Reply To: Running VBScript through SQL Server Agent Job -- Hanging @ Connection to DB

EsquireDeveloper wrote:
Hi Jeff,
This process was originally written in VBA, in an MS Access Application. We have moved our back end to Azure SQL Server, so it was easiest for me...
--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)

May 10, 2020 at 12:26 am

#3750237
Reply To: Update duplicate values to 0

Just a personal habit of mine... I don't update such data because, if someone adds interceding data, you might not be able to determine what should happen to it because...
--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)

May 9, 2020 at 11:48 pm

#3750236

Viewing 15 posts - 7,141 through 7,155 (of 59,102 total)