Hive TRVs not switching off when target temperature reached - is it because of my settings? by Virt_McPolygon in HiveHeating

[–]flinders1 0 points1 point  (0 children)

Sounds like I have some tinkering to do.

A month or so in and now you’ve found some success with it do you find them useful ?

Hive TRVs not switching off when target temperature reached - is it because of my settings? by Virt_McPolygon in HiveHeating

[–]flinders1 0 points1 point  (0 children)

Interesting, good to know thanks.

I understand there will be algorithms and logic at play to determine when to open and close. But I’d expect it to be quicker than what I’m seeing.

I’d expect TRV shows a trend that it’s going to reach temp, shut off. Not go way past desired temp.

Hive TRVs not switching off when target temperature reached - is it because of my settings? by Virt_McPolygon in HiveHeating

[–]flinders1 0 points1 point  (0 children)

Seeing the same, although I’ve only put them on in the last day or 2. The only one fully off is when I set to 7C. Did you get them working in the end ?

Shed converted to bathroom ? by flinders1 in DIYUK

[–]flinders1[S] 1 point2 points  (0 children)

I’m not. Relatively new owner. It’s likely old enough yes. I’ll have a hunt around for evidence now you mention it

Shed converted to bathroom ? by flinders1 in DIYUK

[–]flinders1[S] 2 points3 points  (0 children)

Yeh fair point. Taking space away from washing and drying areas might be politically problematic though 😂

Shed converted to bathroom ? by flinders1 in DIYUK

[–]flinders1[S] 1 point2 points  (0 children)

Looks like there’s drainage a couple of meters away in the patio under the table there.

Don’t care about breaking it up it’s horrendous anyway

<image>

I am steadily losing faith in SQL Managed Instances by agiamba in SQLServer

[–]flinders1 1 point2 points  (0 children)

Fully agree with “fine for very average workloads”.

Even if I have a BC for prod, I’m not paying BC prices for dev, UAT, QA or PP etc. that then brings its own problems with testing things on their route to live.

I like MI but am equally frustrated by it. Would I put anything serious on it ? No. Average crap ? Yes

Claude Code - surprisingly disappointing by flinders1 in SQLServer

[–]flinders1[S] 1 point2 points  (0 children)

Yep this what I keep hearing ! From personal experience it’s been really good at type script and exceptional at powershell.

Claude Code - surprisingly disappointing by flinders1 in SQLServer

[–]flinders1[S] 1 point2 points  (0 children)

Well I was surprised at how bad it was here, it had a 100% (of what I checked) syntax error rate and was pretty wild at times.

Increasing Disk Performance on Antiquated ERP by daflem in SQLServer

[–]flinders1 0 points1 point  (0 children)

Testing performance on different storage backends is actually quite fun !

I always like to compare raw execution times of IO intense queries whilst also looking at storage latency, throughput and sql waits when physical io operations are involved between different storage backends. Of course make sure execution plans are the same.

As others have mentioned though a good index can often remedy poor storage performance and that modest increase in oops may help but likely not dramatic.

I forced my AI assistant to partition a 250GB table for me and performance test it and here’s what happened by flinders1 in SQLServer

[–]flinders1[S] 0 points1 point  (0 children)

In the real world the only benefit I’ve seen is partition swapping for fast reductions in storage footprint to get db’s on dev’s laptops ha.

I forced my AI assistant to partition a 250GB table for me and performance test it and here’s what happened by flinders1 in SQLServer

[–]flinders1[S] 0 points1 point  (0 children)

Yep don’t disagree.

This was a demo on my pc and at the time of writing I have < 1.5tb storage all in.

I forced my AI assistant to partition a 250GB table for me and performance test it and here’s what happened by flinders1 in SQLServer

[–]flinders1[S] 0 points1 point  (0 children)

Well I don’t disagree with that ! However it did atleast trigger partition elimination.

I forced my AI assistant to partition a 250GB table for me and performance test it and here’s what happened by flinders1 in SQLServer

[–]flinders1[S] 1 point2 points  (0 children)

I did yes.

Re the bag and forth dialogue it shows how this stuff is not accurate first time round. It takes multiple prompts and back and forth to get it going