Viewing 15 posts - 406 through 420 (of 59,048 total)
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...
August 6, 2024 at 6:15 pm
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.
August 6, 2024 at 6:10 pm
I probably wouldn't compete. I'd probably teach.
August 4, 2024 at 7:35 pm
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...
August 3, 2024 at 3:25 pm
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...
August 3, 2024 at 2:59 pm
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...
August 3, 2024 at 2:06 pm
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...
August 3, 2024 at 2:55 am
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...
August 2, 2024 at 6:05 pm
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...
August 1, 2024 at 9:28 pm
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...
July 31, 2024 at 3:12 pm
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.
July 31, 2024 at 2:42 pm
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...
July 27, 2024 at 9:23 pm
Nope... not "WE"... "THEY".
THEY have gotten arrogant... every damned one of them.
July 27, 2024 at 4:59 am
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...
July 25, 2024 at 11:01 am
Do a COUNT on both columns using GROUP BY and add a HAVING where the COUNT(*) = 1.
July 25, 2024 at 5:07 am
Viewing 15 posts - 406 through 420 (of 59,048 total)