Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,201 through 1,215 (of 59,065 total)

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
Reply To: TRY-CATCH blocks ignore converting errors in ORDER BY statement

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 ORDER BY. ...
--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:09 pm

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

Lynn Pettis wrote:
Jeff Moden wrote:
jonathan.crawford wrote:
Trying to imagine a scenario where I worked with Jeff Moden and tried to call out his code...
Gosh... thanks for the very kind words but I'm far...
--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 2:07 am

#4263151
Reply To: SQL 2014 Standard - All SQL agent jobs disabled after patch

I've never seen anything like that from a CU before. What happens when you re-enable the jobs?
--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 2:04 am

#4263150
Reply To: High CPU & blocking

His name is "Hallengren". 😉

ramana3327 wrote:
Hello SQL Experts,
Followed the guidance provided by Microsoft.
What guidance??? Be specific because, if they have to do with indexes, MS finally figured out what 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)

August 17, 2023 at 1:59 am

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

Emperor100 wrote:
Building a new logic may take time plus avoiding certain characters, or keeping a conversion table and when there no resource available, why don't you expand the field itself. ...
--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 16, 2023 at 3:39 pm

#4262757
Reply To: Color Particular Column

jagjitsingh wrote:
Hi
In Sql Query or using Stored Procedure
Thanks
Such formatting can, indeed, be done in a query or stored procedure. My "Morning Report" emails I get from the servers are proof...
--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 15, 2023 at 7:07 pm

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

jonathan.crawford wrote:
Trying to imagine a scenario where I worked with Jeff Moden and tried to call out his code...
Gosh... thanks for the very kind words but I'm far from perfect. ...
--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 15, 2023 at 6:50 pm

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

ZZartin wrote:
You'd think someone working in it would know how to ask for help properly..... developer just sent me.
"the UAT ETL server seems to be really slow this morning. Any...
--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 15, 2023 at 6:09 pm

#4261957
Reply To: Multi-user use the database at the same time(HOW)

I totally agree with Grant. IMHO, what he's recommending (AD Groups a.k.a. Active Directory Groups) is the only way to go on something like this.

--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 14, 2023 at 1:55 pm

#4260914

Viewing 15 posts - 1,201 through 1,215 (of 59,065 total)