Jeff Moden

Forum Replies Created

Viewing 15 posts - 466 through 480 (of 59,091 total)

Reply To: what have people done for ssrs params needing very precise start and end times

stan wrote:
Hi we run 2019 standard. one of our mfg locations requires somewhat precise start and end param times along with the start and end dates controlling how an ssrs...
--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 9, 2024 at 5:01 pm

#4443566
Reply To: Returning the Top X row for each group

Steve Collins wrote:
Jeff Moden wrote:
I did? I don't remember... I've gotten old enough where I think my harddrive is full and, every time I learn something new, either something else in...
--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 8, 2024 at 10:08 pm

#4443361
Reply To: Relationally Divided over EAV

webrunner wrote:
I'm a little late to the party due to the repost. But I look forward to reading more on this topic. We had a really terrible EAV implementation, so...
--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 8, 2024 at 9:26 pm

#4443336
Reply To: Returning the Top X row for each group

Dave Ballantyne wrote:
14 YEARS ago, my god! Always makes me feel warm inside when then notification of such a blast from the past lands in my inbox.
Maybe its time not 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)

August 6, 2024 at 6:32 pm

#4442819
Reply To: Returning the Top X row for each group

Steve Collins wrote:
In another topic Jeff Moden mentioned he has a "package" which compares SQL across different year releases.
I did? I don't remember... I've gotten old enough where I think...
--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 6, 2024 at 6:15 pm

#4442812
Reply To: Returning the Top X row for each group

ratbak wrote:
From the wayback machine: https://web.archive.org/web/20111212031052/http://beyondrelational.com/blogs/madhivanan/archive/2008/09/12/return-top-n-rows.aspx
Holy shades of Herman and Mr. Peabody! I always forget about the "Wayback" machine. Thank you for posting that link.
--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 6, 2024 at 6:10 pm

#4442811
Reply To: What Sport Would You Play?

I probably wouldn't compete. I'd probably teach.
--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 4, 2024 at 7:35 pm

#4442299
Reply To: A Different View of Technical Debt

Steve Jones - SSC Editor wrote:
I also think that for lots of core software (OS, SQL, .NEt, others), the vendors have a sales issue in that they need to keep building things, and also...
--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 3, 2024 at 3:25 pm

#4442140
Reply To: Returning the Top X row for each group

More people need to know about the method that Dave showed in this article.
On modern machines, we still get 3 orders of magnitude difference in CPU and Duration (shown 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)

August 3, 2024 at 2:59 pm

#4442139
Reply To: Returning the Top X row for each group

Madhivanan-208264 wrote:
More methods are available here http://beyondrelational.com/blogs/madhivanan/archive/2008/09/12/return-top-n-rows.aspx
It's a real shame that websites don't last forever. I'll bet that was interesting especially based on the old "beyondrelational" site, which was an...
--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 3, 2024 at 2:06 pm

#4442134
Reply To: Displaying Sorted Hierarchies (SQL Spackle)

sholliday wrote:
Is there a way to get the complete hierarchy for a single Employee?
Again, apologies for the miss all these years ago. The forum did have problems with notifications...
--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 3, 2024 at 2:55 am

#4442064
Reply To: Displaying Sorted Hierarchies (SQL Spackle)
denisribeiro wrote:
Great post! So, how can I do this with desc order by?
Sorry I missed this way back when. If you're still around, let me ask you 2 questions...
1. What...
--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 2, 2024 at 6:05 pm

#4442001
Reply To: Why doesn't the error show up in the SQL Log?

This is one of the reasons why I generally don't care for "Try/Catch" in code in relation to jobs and database code. If people don't write it correctly, the calling...
--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 1, 2024 at 9:28 pm

#4441771
Reply To: A Different View of Technical Debt

David.Poole wrote:
I think we should keep in mind what the upgrade path looks like. Upgrades between X and X+1 I would expect to be relatively painless.
Upgrades from X that skip...
--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)

July 31, 2024 at 3:12 pm

#4441456
Reply To: A Different View of Technical Debt

The post above is the first post on Page 2 and wasn't showing because of problem on this site. This post will make the post above appear.

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

July 31, 2024 at 2:42 pm

#4441451

Viewing 15 posts - 466 through 480 (of 59,091 total)