Stack Exchange
log in

Josh Darnell

 The Heap™ – Consultancy ©®

General on- and off-site discussion for dba.stackexchange.com....
5
1
Josh Darnell
Wed 15:28
@PeterVandivier Don't talk about Joe like that.
3
Josh Darnell
Wed 13:03
Sad
Josh Darnell
Wed 12:49
@PaulWhite I imagine they're illegal in California.
Josh Darnell
Wed 12:48
@PaulWhite Oh yikes.
Josh Darnell
Wed 12:42
Maybe the technique is more targeted towards restaurants.
Josh Darnell
Wed 12:42
Not sure who has the flimsy grocery store vegetable bags on hand at home.
Josh Darnell
Wed 12:41
That's what I was remembering.
Josh Darnell
Wed 12:41
youtube.com/shorts/C4kk0u62hJ8
Josh Darnell
Wed 12:38
@PaulWhite 😅
Josh Darnell
Wed 12:36
I remember seeing a video of some clever way to fish the cork out of the bottle. But now I can't remember the technique. It was probably staged.
Josh Darnell
Wed 12:33
Perhaps hidden under a broken piece of cork.
Josh Darnell
Wed 12:33
Maybe the irony got lost somewhere.
Josh Darnell
Wed 12:32
@Charlieface I don't mean to attack. Sorry about that. I was trying to pedantically correct your pedantic correction (which was incorrect, or at least irrelevant).
Josh Darnell
Wed 12:31
@PaulWhite Thanks for being more precise about that 😉
Josh Darnell
Wed 12:26
> A bit string or byte string, for example, may be used to represent non-textual binary data retrieved from a communications medium.
Josh Darnell
Wed 12:25
And you think that's what Paul is talking about when he says "strings were a mistake?"
Josh Darnell
Wed 12:11
It just feels like your whole "bare string of bytes" thing is a non-sequitur.
Josh Darnell
Wed 12:10
> In computer programming, a string is traditionally a sequence of characters, either as a literal constant or as some kind of variable.
Josh Darnell
Wed 11:58
That's such an odd distinction to try to make.
Josh Darnell
Tue 22:09
Plans have statuses and sub-statuses?
Josh Darnell
Tue 22:09
Wooden dowels.
Josh Darnell
Tue 22:08
Seems like it would be a little simpler as just "id"
Josh Darnell
Tue 21:33
More subtle powers.
Josh Darnell
Tue 21:33
Oh even better.
Josh Darnell
Tue 21:33
Kick them, Paul. You have the power.
Josh Darnell
Tue 21:25
I personally don't mind the Id columns, since we're always aliasing tables anyway. But I do get the argument.
Josh Darnell
Tue 21:23
> As an aside, I also think it is worthwhile to name your primary identifier in full (e.g. Products.ProductID instead of Products.ID) so that the identifier is consistently named throughout the schema.
Josh Darnell
Tue 21:23
8
A: Do I need a separate Id column for this "mapping" table?

Aaron BertrandNo, there is no value in adding an additional "primary key" to this table. Your joins are only ever going to refer to ProducerID and ProductID, so it is just dead weight. IMHO. Though I agree with @Shark that the join table doesn't even seem to be needed here, unless you are going out of your wa...

Josh Darnell
Tue 21:23
Aaron called me out on that in one of my very first interactions on this site.
Josh Darnell
Tue 21:23
I think so.
Josh Darnell
Tue 16:42
It's so specific.
Josh Darnell
Tue 16:42
@Yano_of_Queenscastle — thanks for the assist. Turns out I didn’t have it installed. I had assumed that starting with SQL Server 2012, sp_BlitzLock was included by default on the instance. — DevOpsLens 20 hours ago
Josh Darnell
Tue 13:16
🤣🤣🤣
Josh Darnell
Tue 13:07
> Need intro
Josh Darnell
Tue 13:07
Access releases bug fixes in version 2506
Josh Darnell
Jul 18 13:59
"American trains" lol
4
Josh Darnell
Jul 17 17:54
@ErikReasonableRatesDarling Absolute madman.
Josh Darnell
Jul 17 17:30
@ErikReasonableRatesDarling I've never heard that, what do you mean? Is it because the water ends up being too hot?
Josh Darnell
Jul 17 17:28
@SeanGallardy Ah well that is a bummer.
Josh Darnell
Jul 17 16:06
"why would you cover up the tile like that?!" the man says right before covering it back up 🤣
Josh Darnell
Jul 14 15:50
@ErikReasonableRatesDarling Most wizards do.
Josh Darnell
Jul 12 02:12
Thank you for completing the ritual!
Josh Darnell
Jul 11 17:58
ayende.com/blog/202851-C/ravendb-7-1-the-gen-ai-release - man, that's a pretty neat thing to have running amok in your database.
Josh Darnell
Jul 11 15:36
@SeanGallardy No problem!
Josh Darnell
Jul 11 14:54
user image
Josh Darnell
Jul 10 22:39
"completely and utter hosed" -> "completely and utterly hosed"
"software as" -> "software as it"
Josh Darnell
Jul 10 18:50
Sorry, @Hannah. That's awful!
Josh Darnell
Jul 10 17:30
Oh hi hello
Josh Darnell
Jul 8 20:05
@J.Mini udemy.com/user/edwinsarmiento
Josh Darnell
Jul 8 20:03
@SeanGallardy Sorry! :)