The Heap™ – Consultancy ©®

12:04 AM

You should build Paul a sandwich shop

mmmm sammich. It is lunchtime here

@ErikDarling Don't know. But this looks like an excellent drill press

trademe.co.nz/4689614407 three phase, auto downfeed, weighs more than two cars.

Compared to the one I have now

sorry - getting a little off topic there

Nothing is off topic

12:35 AM

so.... try harder ?

12:57 AM

Try as you might

2 hours later…

2:31 AM

@Criggie Star Link

@SeanGallardy Same here

@PaulWhite Starlink doesn't do IPv6, and its consumer only so no services offered. I want a mail server and so on.

I'd rather colocate a host or buy a VM somewhere than contribute to the manboy.

Hannah Vernon

Agreed

@Criggie as long as you remember it's always morning in The Heap

okay - machinery porn time.

75 year old sewing machine.

murder weapon

rrrrrrRrRrRrRrRrRrRrRrRrRrRrRrRrRrRrRrRrRrRrRrRrRrRrRrrrrrr.

2:45 AM

criggie the seamster

Seems they have weird short needles, and using long/normal ones buggers up the bobbin case.
THis one was only $60, and a bobbin case is $15 on aliexpress.

I think I come out ahead here.

@ErikDarling sew what ?

oh nothing just sounds like a skyrim character

go see criggie the seamster to get the thane's pants fixed

maybe jarl

Funny story - I got given a singer 201k in ~2001 by the school I worked in. I was a 1955 model and had done all its life in a girls' high school.
So I gave it to my GF at the time, then later married her. Now its in my house and she wants to keep it. Fair enough. So I bought the one above for me.

I'm more of a mender than anything serious.

Josh Darnell

3:06 AM

@Criggie that machine is not having any kind of sex that I can tell.

False advertising.

dunno, looks a bit like it's on all fours

or... whatever number.

divided by zero.

@JoshDarnell i spoke to someone today who was absolutely sure that they only way they could update a column using entity framework was to update every column in a table. i thought it sounded quite strange.

3:42 AM

eewww - an on-topic statement ?! Icky

1 hour later…

5:11 AM

@Criggie Star Link does have IPv6 and you can order their Business offering in NZ today. Vodafone and 2 degrees are in the final stages of offering it as a reseller. True about email, if you really need ISP hosted for some reason. starlink.com/nz/business

I refuse to call them One NZ because it's stupid

2degrees.nz/business/broadband/starlink-business-services

one.nz/business/broadband/starlink

5:49 AM

exactly - its "shell" not "zee"

OMG I just realised - same as my grandparents referring to Arthur Barnetts as DIC

imma getting old

Hannah Vernon

Wordle 1,048 3/6*

🟨⬛🟩🟨⬛
⬛🟩🟩🟩⬛
🟩🟩🟩🟩🟩

Vérace

6:13 AM

A chairde - Morning all!

Wordle 1,048 5/6

🟨⬛⬛🟨⬛
🟨🟨🟨⬛🟨
🟩🟩⬛⬛🟩
🟩🟩🟩⬛🟩
🟩🟩🟩🟩🟩

6:35 AM

Wordle 1,048 6/6*

⬜🟨⬜⬜🟨
🟩⬜⬜🟨⬜
🟩⬜⬜🟨🟩
🟩🟩⬜⬜🟩
🟩🟩🟩⬜🟩
🟩🟩🟩🟩🟩

Bicycle theme

1 hour later…

Our BIGGEST Machine for The Workshop! | Huron LU Milling Machine

7:48 AM

Michael Green

@Criggie proper shed envy:

►

2 hours later…

9:40 AM

green, like Jelly, I am./

2 hours later…

11:23 AM

I've searched 'yugabyte' on the dba SE and only 3 hits were from @Vérace

Cade Roux

Vérace

11:38 AM

@Zikato Yaay! At last... my 15kb of fame! :-)

According to here, it's just outside the top 100 (102) of all systems and the top 50 (51) of RDBMSs!

Not a recommendation of db-engines I hasten to add - but faute de mieux I'm using it!

@Zikato Out of curiosity, why were you interested in Yugabyte?

I saw someone who had it on CV

12:27 PM

Was it above or below 'regex'

And was it from an Irishman

1:26 PM

That's classified

Vérace

Don't misunderestimate regexes!

I'm planning to rewrite SQL Server in PostgreSQL's regular expression dialect. Should be a big project - take at least a couple of weeks!

2:13 PM

We look forward to you checking back in after a fortnight of diligent endeavoring.

Josh Darnell

@ErikDarling That does sound strange. EF's change tracker normally tracks which fields you've actually modified in memory, and only includes those in the generated UPDATE statement.

@Vérace we can compare regex notes

You should make a regex to compare regex

regexception

a single connection inserting in to a heap is blowing out the Azure SQL DB's log throughput.

Thats what I get for using a 2-vcore db I guess

2:40 PM

You could be on the largest instance type known to the cloud and still do that

Facts.

@SeanGallardy It's always problems in the Heap

Meanwhile, my laptop form 2014 has better throughput and lower TCO.

@JoshDarnell yeah, I’ve heard many bad things about EF over the years, but that has never been one of them. The lack of bulk updates and inserts is a more common gripe (though I think inserts got some relief recently?)

Just sucks, trying to repro an issue and it's taking forever since I need to specifically blow out the log.

2:42 PM

@SeanGallardy there’s still time

Josh Darnell

@ErikDarling Bulk updates and deletes got a big upgrade. Inserts got a weird batching improvement.

There's really no need to log the contents of many bulk heap loads

Unlogged tables when

> Current Bid:
$100,170.00

Reasonable

For 334 TB of memory and 145k cores

@ErikDarling It's ridiculous it hasn't been done already

2:43 PM

It would also be a decent workout getting those moved

I need the logging though, the log write speed is abysmal

Yeah, I'm speaking generally, not about whatever tedious shit you have to do

@PaulWhite agreed. Seems like basic scalability optimization territory.

One day I'll have my house, running off my own generated power, in the middle of 2,000 acres and no neighbors in sight.

I can spend my days outdoors

> and the body never was found

2:45 PM

perks of 2k acres

@ErikDarling No doubt people worry about replication and AGs etc. but there's really no need, it almost always a single instance temporary thing

landwatch.com/…

> Spanning over 16 miles north to south and nearly 10 miles east to west

XVI miles and X miles

@PaulWhite that’s exactly what I’d worry about getting bogged down by large staging table loads! Because people really seem to love having DR for a DW.

Really is crazy

I suppose loading tempdb is the closest approximation

3:02 PM

That’s not a bad idea. Put your data warehouse all in tempdb.

I guess, even with a "non-logged" table, you'd still have to do allocation transactions

Maybe a filegroup marked as non-logged and then non-transactional allocation tracking?

Just trying to think how that'd work in the current standbox that is SQL

3:19 PM

Reverse truncate

2 hours later…

Q: Problem with Czech collation Czech_CI_AI in MS SQL Server 2008 R2

5:15 PM

I have the following issue with accent insensitive search in Czech language. My database is set to Czech_CI_AI collation. For some diacritics system works correctly (ie. I), but for some does not (ie. R). In my database there are several 'DVORA*' records: SELECT contact_name FROM CONTCTSM1 ...

Ah, hadn't noticed it's so old. It showed on the top of my feed because of recent "answer"

1 hour later…

6:38 PM

lol

6:59 PM

What's that?

PSP would be my guess

7:17 PM

Nope

Just a stored procedure with a few different variations on the same query

Forrest

so it chooses which hints to use?

I’m choosing which hints manually

I just think the numbers are funny

7:39 PM

There are only two funny numbers and it has neither of those

7:50 PM

80085 and what else

8:01 PM

8:17 PM

9:11 PM

this is a perfectly legal update query: UPDATE u SET u.Age = 138 WHERE u.Id = 22656;

there's no table reference of course

i wonder what gets updated

mustaccio

> i wonder what gets updated

nou

oh it turns out i had a view named u

existential crisis averted

mustaccio

9:42 PM

it was a vu

9:59 PM

i almost didn’t know what to du

10:49 PM

You need a vu meter .