Jeff Moden

Forum Replies Created

Viewing 15 posts - 781 through 795 (of 59,091 total)

Reply To: SQL 2022 performance

Thank you both!
We had to upgrade because of "corporate policy". We were at 2016. 2017 doesn't have the horrible performance issues that 2019/2022 has. Even a super simple Tally function...
--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)

February 12, 2024 at 10:55 pm

#4377573
Reply To: SQL 2022 performance

CreateIndexNonclustered wrote:
SQL 2022 will give you batch mode execution plans on indexes that are not columnstore, even if batch mode execution plans are slower.
Did you look at the execution plans...
--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)

February 12, 2024 at 4:32 pm

#4377406
Reply To: Dimensional Modeling Case Study Part 2 - Days Dimension

@lisa,
My whole point is that the use of a function for such temporal range labeling is actually easier for the users to use because they don't need to us 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)

February 10, 2024 at 12:33 am

#4376219
Reply To: Do You Have a Jeff?

Steve Jones - SSC Editor wrote:
... and a few things came together recently that reminded me of you.
Oh my. I can only imagine. Any chance of you sending an email about that? I'm just...
--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)

February 9, 2024 at 11:53 pm

#4376194
Reply To: Do You Have a Jeff?

Steve Collins wrote:
Back in the day, before SQL Server 2012 was previewed, I worked on a project which started with a blank database. My teammate at the time started sending 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)

February 9, 2024 at 8:10 pm

#4376118
Reply To: Do You Have a Jeff?

SoCal_DBD wrote:
I've been a member of this forum for 17 years, mostly a lurker with very occasional posting or replying. I am the baby Jeff at my company. My scope...
--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)

February 9, 2024 at 7:22 pm

#4376091
Reply To: Do You Have a Jeff?

Phil Parkin wrote:
Note to self: remember to rent a Lambo one day.
😀

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

February 9, 2024 at 7:08 pm

#4376090
Reply To: Do You Have a Jeff?

David.Poole wrote:
Whether you are a Brent or a Jeff there are some pitfalls to watch out for to avoid burning yourself out.
Do others see you as a leg up or...
--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)

February 9, 2024 at 3:49 pm

#4376003
Reply To: User-Friendly Task Executor / Scheduler

Phil Parkin wrote:
We have a requirement to allow certain nominated users to execute 'jobs', where the definition of a job could be running a stored proc, or a PoSh script, or...
--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)

February 9, 2024 at 3:01 pm

#4375967
Reply To: Do You Have a Jeff?

Whoa... oh my... now there's a subject I didn't plan on reading about tonight. Other than stating that my levels of imposter syndrome just shot through the roof, I'm not...
--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)

February 9, 2024 at 3:13 am

#4375671
Reply To: xp_dirtree

MrBen wrote:
Just curious why there appears to be a difference with c:\ and UNC.
It depends on where thing are at and where you're running the command from. For example, if...
--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)

February 8, 2024 at 6:20 pm

#4375481
Reply To: Dimensional Modeling Case Study Part 2 - Days Dimension

Heh... no... I agree... BBFAATT will never be able to compete with RBAR.
Also, sorry about your argument with set-based v.s. RBAR thing. I'd have to see what the two things...
--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)

February 8, 2024 at 5:41 am

#4375168
Reply To: Dimensional Modeling Case Study Part 2 - Days Dimension

And, sorry... I forgot that it's a bit new... "BBFAATT" is pronounced as "bee-bee-fat" and is my acronym for "Books, Blogs, Forums, Articles, AI, `Tubes, and Talks".
Heh.. and if sarcasm...
--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)

February 8, 2024 at 3:09 am

#4375091
Reply To: Dimensional Modeling Case Study Part 2 - Days Dimension

Lisa Slater Nicholls wrote:
Fair point @jeff, but I think Ron and many other people who build DWs (or Power BI developers?) are more concerned with making the data, and potential calculations, as...
--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)

February 8, 2024 at 3:03 am

#4375090
Reply To: Dimensional Modeling Case Study Part 2 - Days Dimension

RonKyle wrote:
You may have never seen a good data warehouse. The advantages over standard reporting procedures are significant. Calculations such as YTD, PTYD and the comparisons of the two, rolling...
--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)

February 8, 2024 at 2:39 am

#4375085

Viewing 15 posts - 781 through 795 (of 59,091 total)