Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,231 through 1,245 (of 59,099 total)

Reply To: Is it a good option to store monthly total in database?

Mr. Brian Gale wrote:
Why bother storing something that you can calculate out when you query the data?
To get sheer, blinding, speed. It's the basic method that Pre-Aggregation through Indexed Views work. 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)

August 24, 2023 at 1:01 am

#4269610
Reply To: Space is not getting freed up when deleting data from a log table.

vsamantha35 wrote:
Hi All,
We are trying to delete data from a large 5TB log table. We are able to delete the data but that is not shown up in the free...
--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)

August 24, 2023 at 12:39 am

#4269595
Reply To: How to get max date for each column in SQL Server

Krish319 wrote:
Hi Phil Parkin,
This is working on the sample data I created.
But If I apllied on my original table I am getting below error.
Invalid length parameter passed to 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)

August 23, 2023 at 5:16 pm

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

Brandie Tarvin wrote:
Jeff Moden wrote:
Thom A wrote:
As we're sharing "new job" pains, we're likely going to be are taking responsibility of IT services for our parent company in the month months (years).
Ok......
--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)

August 23, 2023 at 4:47 pm

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

Thom A wrote:
Jeff Moden wrote:
Ok... let's all gather hands in a circle around Thom and repeat the DBA prayer with me...
I'm not sure the strength will help me as it's likely to...
--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)

August 23, 2023 at 3:34 pm

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

Michael L John wrote:
At my new position, DISTINCT is the default for every query. Nobody knows why they do it. There is a fairly large group who is 100% dedicated to creating...
--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)

August 23, 2023 at 3:22 pm

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

Thom A wrote:
As we're sharing "new job" pains, we're likely going to be are taking responsibility of IT services for our parent company in the month months (years).
Ok... let's 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)

August 23, 2023 at 3:11 pm

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

Brandie Tarvin wrote:
jonathan.crawford wrote:
Trying to imagine a scenario where I worked with Jeff Moden and tried to call out his code...
Jeff, Tally tables aren't working and this RBAR thing is RIDICULOUS....
--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)

August 23, 2023 at 3:03 pm

#4269220
Reply To: Use Alpha characters instead of expanding field

Understood. That's why I suggested that your first take on the subject is probably your best take.
To prevent any overlapping of old vs new, leave everything you currently have alone. ...
--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)

August 23, 2023 at 1:45 am

#4268626
Reply To: Determine if value occurred within all shifts

jcelko212 32090 wrote:
Nominal scales are modeled as character strings, not integers.
Instead of the normal long retort that proves you wrong that subject, I jump straight to the punchline this time......
--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)

August 23, 2023 at 1:34 am

#4268625
Reply To: Performance related issue in the report after adding new table in the sp .

Recommendation: When posting performance issues, please follow the guidelines posted in the article at the 2nd link in my signature line below.

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

August 23, 2023 at 1:28 am

#4268623
Reply To: Use Alpha characters instead of expanding field

Yep... there's the "can thing" and understood.
Since values from 000 thru 999 have already been distributed, we can't just use the simplicity of base 36 so I guess I'd do...
--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)

August 21, 2023 at 5:02 pm

#4267337
Reply To: A Real World Clash with AIs

David.Poole wrote:
After migrating a massive number of documents for the AAIB and MAIB earlier in my career I became and avid watcher of Air Crash Investigation. One fatal...
--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)

August 21, 2023 at 12:31 pm

#4267138
Reply To: TRY-CATCH blocks ignore converting errors in ORDER BY statement

kyagi.jo wrote:
Jeff Moden wrote:
The reason why the code doesn't produce an error can be found in the execution plan. Apparently, since SQL knows there's only 1 row, it never executes 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)

August 17, 2023 at 7:20 pm

#4263893
Reply To: What's the right way of capturing expensive queries?

It's like the ORDER BY in the second query. Do the ORDER BY using the column aliases for the SUMs rather than the SUMS themselves.
--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)

August 17, 2023 at 5:26 pm

#4263821

Viewing 15 posts - 1,231 through 1,245 (of 59,099 total)