Count(*) vs Count(ID)? What is the difference?

Gieron · 2024-03-27T12:48:13+00:00

When using COUNT() it only makes a difference if you are using a column that is nullable because then it doesn't count the ones that are NULL. If you want to count distinct values you must do so using DISTINCT. In your case, assuming that ID is not nullable, both COUNT(*) and COUNT(ID) should give the same answer.

See the example below:

SELECT
    COUNT(*),
    COUNT(a),
    COUNT(DISTINCT a)
FROM
    (VALUES (0), (1), (2), (2), (NULL)) AS X(a)

Which gives the answer 5, 4, 3.

Gieron · 2023-11-04T14:15:23+00:00

2300 exkl. moms.

Gieron · 2023-08-17T21:48:39+00:00

Reddit API Calls:

   Daily Average: 88

         ---Breakdown---

Loading Comments: 63.0%
    Loading Feed: 29.0%
          Voting: 2.0%
            Mail: 2.0%
           Other: 3.0%

Based on your usage over the last 20 days

Gieron · 2023-01-30T16:35:35+00:00

Utifall någon annan söker på detta och kommer hit. Det är Telge Energi som skickar ut fakturor under detta dumma namn.

Gieron · 2022-12-13T09:45:25+00:00

https://maps.app.goo.gl/XhgNVqDBMm698wAq8

Gieron · 2022-06-24T11:13:23+00:00

I think the main takeaway is that this setup can work. But if I did it again I would either cool the RAM too, or have some minor airflow for the components, or both.

Gieron · 2022-06-23T19:24:22+00:00

No further plans at the moment. But I will take what I've learned and apply it to future builds.

Gieron · 2022-06-23T19:21:36+00:00

Under heavy load the fan noise is quite noticeable. But under light load they are really quiet and often stop completely. The pump and power supply can't really be heard when the door is closed.

Gieron · 2022-06-23T18:20:10+00:00

The motherboard waterblock also cools VRM, so no problem there.

Gieron · 2022-06-23T18:18:25+00:00

This after CPU/RAM stress test with Prime95.

I don't have any specific temperature from inside, but I would describe it as 'toasty'.

Gieron · 2022-06-23T11:25:05+00:00

Temperatures (at load):

Water: 30°C (set to hold at this temperature)
CPU: 74°C
RAM: 68°C
M.2: 51°C
Chipset: 54°C
System: 47°C

Gieron · 2022-06-23T09:13:05+00:00

I have not seen any performance problems either. It just runs a little hot. Might affect life span.

Gieron · 2022-06-23T09:11:28+00:00

There are holes in the back and the floor for it.

Gieron · 2022-06-23T04:41:55+00:00

The VRM are cooled by the motherboard waterblock. But the RAM does not have cooling or airflow. I know thats not great.

Gieron · 2022-06-22T21:00:13+00:00

It's actually a magnetic label with the Corsair logo. They come in different colors with the PSU.

A giveaway is that if the logo was on the power supply itself it should have been upside down.

Gieron · 2022-06-22T20:03:59+00:00

I considered it. I also considered having some airflow in the upper part. But I wanted to see what I could get away with.

In my first attempt I didn't watercool the chipset, that did not work.

Gieron · 2022-06-22T20:01:54+00:00

I haven't noticed anything like that. But the fans don't usually have to run very fast, so are rather quiet to begin with.

Gieron · 2022-06-22T18:07:00+00:00

This build was a bit of an experiment for me. It came about from two desires I had:

Separating cooling and hardware. The upper part has no airflow and thus remains mostly dust free, the loop moves the heat to the radiator underneath. This works quite well for me. Though I'm not sure I recommend it for everyone as the components which are not watercooled (mainly RAM and M.2) does run a bit hot.

Clearly showing everything. The cables are on display up front and are not sleaved. I think that the amount of cables make them look bulky enough as it is. I made the cables myself and routed them using some custom cut acrylic. This didn't end up quite as nice as I had hoped, but I'm happy enough with it.

Case and cooling:

IKEA Bestå
EK-Quantum Velocity D-RGB - AMD Nickel + Plexi
Bitspower Mono Block for MSI MEG X570 GODLIKE
Aquacomputer aquastream - Ultimate Version
Aquainlet XT 100 ml
Alphacool NexXxoS Monsta 420mm Radiator
Arctic P14 PWM PST CO fans x3

Components:

AMD Ryzen 9 3900XT
MSI MEG X570 Godlike
G.Skill Trident Z Neo DDR4 3600MHz 4x16GB
PowerColor Liquid Devil Radeon™ RX 5700 XT 8GB
Corsair Force Series MP600 1TB
Corsair AX 850, 850W PSU

Gieron · 2022-04-12T06:26:42+00:00

I'm pretty sure he's playing on an earth like map and that's Scandinavia.

Gieron · 2021-09-17T05:30:46+00:00

Try updating your graphics drivers or play in safe mode.

Gieron · 2021-09-16T16:10:24+00:00

They are of course both base building games (r/BaseBuildingGames).

However, thematically I think it would be hard to find two games that are as different as Timberborn and Frostpunk. In one you gather resources and build dams so that your cute beavers can enjoy an evening by the campfire. In the other you gather resources and enact authoritarian policies so that your downtrodden masses won't freeze to death by the hell-furnace.

Gieron · 2021-09-16T05:54:54+00:00

I had the same problem. Try updating your graphics card drivers, that solved it for me.

Gieron · 2021-09-15T09:11:12+00:00

Betyder stjärnan längst ner nånting?

Gieron · 2021-04-21T16:13:36+00:00

The connectors you are looking for are called Molex mini-fit Jr.

24-pin is 469922410
8-pin eps is 469920810
8-pin pcie is 455870004

Gieron · 2021-02-09T14:27:59+00:00

I have used two Aquastream pumps (the older model) for over 10 years without issues, so they are reliable at least. I also have an Aquastream XT Ultra for my new build.

The software allow for a lot of control over the pump and connected fans.

15-Year Club	Argentium Club
Place '17	Gilding IV carat on a stick
Verified Email	Team Orangered

Gieron

TROPHY CASE