Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,111 through 7,125 (of 59,072 total)

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
Reply To: Update duplicate values to 0

jcelko212 32090 wrote:
You please post something useful?
Heh... you've been at this for 30 years and you still can't meet your own demands. 😉 Drop the tough guy troll act and post...
--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 10:49 pm

#3750230
Reply To: T-SQL Self Referencing Join

ringovski wrote:
Thanks for the reply, I have resolved the problem with a self referencing LEFT JOIN on the non measure columns.
2 way street here... please post your solution!
--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 10:32 pm

#3750229
Reply To: Selecting data between just month and year

Jeff Moden wrote:
cbrammer1219 wrote:
I know how to get data between just startdate and enddate, but I need to select it between just month and year, start month is previous July and...
--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 10:31 pm

#3750228
Reply To: Error al Importar una tabla con el (SQL Server Import and Export Wizard)

You would probably get a faster response if you did your own translation to English.
--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 9:42 pm

#3750225
Reply To: How can I determine relationships or dependencies between tables or queries?

And one more link by a fellow that I have a strong trust in:
https://www.red-gate.com/simple-talk/sql/t-sql-programming/dependencies-and-references-in-sql-server/
--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 9:01 pm

#3750221

Viewing 15 posts - 7,111 through 7,125 (of 59,072 total)