Jeff Moden

Forum Replies Created

Viewing 15 posts - 436 through 450 (of 59,063 total)

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
Reply To: We Stink!

Ok... talk about stink! Fortunately, they decided not to chance using a faulty space craft (IMHO, it was faulty even at lift off) but check this out.
https://weather.com/science/space/video/astronauts-stranded-in-space-with-no-return-set
https://duckduckgo.com/?q=astronauts+stuck+in+space+2024+boeing
They should jettison 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)

July 27, 2024 at 9:23 pm

#4440432
Reply To: We Stink!

Nope... not "WE"... "THEY".
THEY have gotten arrogant... every damned one of them.
--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 27, 2024 at 4:59 am

#4440313
Reply To: How To Approach Adding A primary Key To An Existing Table

I agree with Brian... check with the 3rd party before you mess with one of their tables. While this is just a simple "audit" table that won't even stand up...
--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 25, 2024 at 11:01 am

#4439768

Viewing 15 posts - 436 through 450 (of 59,063 total)