Many learnings were learned and everyone's super-positive about it all

11points.com/11-ugliest-colors-world

I hope they won't find this ^ site...

Though I must say their intuition didn't betray them the first time

Huh. I quite like lime green

Server Monkey has HP DL380 8th gen boxes with dual 2.5Ghz CPUs and 384GB ram for $499 USD. servermonkey.com/…

@PaulWhite have you seen this?

I haven't had any time to repro it yet, but it seems somewhat interesting in its specificity if nothing else.

@HannahVernon Yep see deleted comments, also the earlier comments on my article by the same user. I invited them to ask here, but did not commit to answering personally.

Awesome

Morning

@Vérace-getVACCINATEDNOW A version that works with the ancient SQL Server 2008 R2 dbfiddle.uk/…

There's also a new (fairly common) case of fixed-length fields e.g. | 123| 456|. Trailing spaces might be less frequently seen, but perfectly possible I guess.

Morning

I'd forgotten how many features don't exist in 2008

A chairde - Morning all!

Paul While I got it working to my satisfaction - doesn't do the fixed width text - again, I'm sure that this can be done given the time and interest!

Err... when I say "I", I mean the kind lad on SO who answered my question - only two downvotes! But not closed! :-) Very nice on the 2008 SQL btw - got a headache just looking at it! :-)

@HannahVernon Hi Hannah, can you tell me a) this kit does come with a power supply? And b) - how do I hook it up to a screen? HDMI? Other? Not much of a hardware guy!

But I am looking for a box for a couple of gigs...

Paul White - the reason I haven't marked as correct and/or upvoted is because all this guy has done is "given me a fish" and not "taught me how to fish" - no explanation as to why my snippet failed - I think I was fairly clear on that it was this that I was after!

@Vérace-getVACCINATEDNOW 7125341246362562654562465 isn't an integer

and it doesn't handle spaces, as you say

@Vérace-getVACCINATEDNOW It's very simple, step-by-step mostly standard SQL

Notice that I"m not doing the @Paul.... as per your request - I get that you must get pinged a lot and it can be annoying - my fiancee was wondering what the hell was going on the day you showed me how tiresome repetetitive burps can be!

Re. your long INT - I haven't wrapped that code in the try_cast yet - I"m on the train! It's good to go though!

Yep I only generally do it if the person hasn't been seen in a while, or if I am responding to a specific message

BTW, feel free to ping me - I don't get notified that frequently!

@Vérace-getVACCINATEDNOW That's not my long number string - I copied it from one of your fiddles

Grand - properly wrapped - it'll work!

Wrapped by the try_cast function?

Yes - from the code yesterday?

Have different machine here on train!

Yes I remember, just confirming what you meant by "properly wrapped"

Most of the SQL Server 2008 R2 code is working around the lack of a try_* intrinsic

just for fun, this accepted as valid SQL, both in Postgres and SQL Server

 select +-+-++-3 ;

Yeah unitary operators FTW

Here we go!

-0 as well

@Vérace-getVACCINATEDNOW So just the spaces failing now

@ypercubeᵀᴹ I'm just wondering why it shouldn't be accepted?

@PaulWhite but we can't have +-+--+3 ;)

@ypercubeᵀᴹ huh weird

@PaulWhite -- is starting a comment!

Yes, the spaces don't work. As I said, diminishing returns!

Wasn't in the spec!

@Vérace-getVACCINATEDNOW oh it should. I don't know if you want to add it in your case. I suppose accepting only a single (+) or (-) is ok.

@ypercubeᵀᴹ oh of course lol

I don't think parsing the integer should involve expression evaluation

+3 would be unusual, but acceptable

same with +0 and -0

mysql is ok with it (+-+--+3). I think it only counts it as comment when the -- is after a space

that's hardly a recommendation

@PaulWhite agreed

I'm in two minds about positive integers having a leading +

TRY_CONVERT allows it but I'm not sure it's common enough to code for

@HannahVernon Don't know about that. The question asks for a lot of work. Seems like they need to hire some help in the real world.

Zero write conflicts under SI is the new zero deadlocks.

@ypercubeᵀᴹ I could add [ ]* before and after my regex? However, I'd just gobble spaces on data entry? More than one way to skin a cat!

Well this sort of data has no place in a database in the first place, as discussed, but it is what it is.

The whole thing is stupid, naturally.

It's evidently pipe=delimited data from an external source. SSIS would be a much better way to ETL that data into a proper database schema.

Yet people insist on using the most expensive and least capable resource for these things.

Paul White "most expensive and least capable resource"! People ;-)

Paul White - final, final fiddle - does spaces also!

@Vérace-getVACCINATEDNOW for you endpointdev.com/blog/2022/01/regex-group-quantifiers-postgresql

@Vérace-getVACCINATEDNOW Looks good to me (aside from all the regex)

@Vérace-getVACCINATEDNOW comes with power supply. It has a VGA port built in for video, but if you're hooking it up to an LCD you'd likely need either an adapter cable or an HDMI video card.

@PaulWhite by "awesome" I really meant "I haven't seen the deleted comments because I'm on mobile" 😁

@HannahVernon thanks for getting back to me! How wouild I hook up a couple of NVMe disks?

@HannahVernon Ah ok yeah deleted comments are tricky to show on mobile. Not impossible, but harder than it ought to be.

a PCIe NVMe controller card. But if it's performance you're after, that machine is used (reconditioned) and certainly not top-of-the-line by today's standard.

@PaulWhite great article on snapshot isolation btw

Paul White - I'll investigate "ranslating" your SQL Server query into PostgreSQL - looks like an interesting exercise...

Re. card - yeah, but it's the idea of having 384GB of RAM that's making me drool! :-) I remember (a while ago now), I was given a work machine with 384MB and I thought I was the dog's!

@Vérace-getVACCINATEDNOW I used a cursor in the end

@Vérace-getVACCINATEDNOW FYI that system comes with 8 x 300GB SAS hard drives which are reasonably speedy, so for a home lab that price is amazing.

@Vérace-getVACCINATEDNOW yeah it's actually a very capable machine at a very reasonable price.

@HannahVernon So no need for SSDs - well, maybe. But this would be perfect for messing with RAID - not my forte - RAID has always been set up for me!

Yep as a hardware lab machine, that can't really be beat. I already have two similar Dell servers otherwise I'd probably buy one.

How much does it weigh? Approx.? I'm thinking postage from the States to Europe!

@PaulWhite hah, just caught that. SET ZERO DEADLOCKS; would be almost as nice as SET FAST I/O; 😁.

@Vérace-getVACCINATEDNOW I'm betting 50 kilos or so

Ha, ha...

So shipping won't be cheap

Seriously?

Had a Solaris workstation "desktop" back in the day that wouldn't have been far off that - sturdy desk required!

Speaking of which - do many of you have standing desks? My financee and I are thinking of getting one - pros/cons?

Well, it's both - you use a handle - I actually prefer it to the electric - better for my green karma man (he says dragging from the huge doobie dangling from his lips...). Price is way better too!

Or was it SunOS? Probably SunOS!

Given that today is the 100th anniversary of the publication of James Joyce's Ulysses, I think I'm going to go with a stream-of-consciousness vibe...

That'll make a change

Morning

No likee:

> We're going to continue to roll out this design to the screens it already most resembles. This includes /questions, tagged questions and search results.

@JohnK.N. - source for this? Is it about the geese who lay the golden eggs (i.e. us) being shat on again?

I understand the reasoning behind the change, but I don't like the layout.

I asked the chatbot how much this weighed? Chatbot sat there for two minutes... the word typing... appeared along with some sort of jiggly cursor thing... typing... refreshing every so often... then the damn thing just went blank!

Can anybody give me a reasonable guesstimate as to the weight of that server with drives &c...?

I estimate it to weigh 28.6 kg.

dell.com/en-ca/work/shop/servers-storage-and-networking/…

@Vérace-getVACCINATEDNOW Remarkably cheap for a machine with 384GB of memory.

Yeah, but shipping 20+kg to Ireland ain't cheap!

@Vérace-getVACCINATEDNOW Back when I was making pimped XW9300s with 15k drives and RAID controllers they got on towards the 25kg mark. Then I worked out I could do the same with a laptop and a SSD.

@Vérace-getVACCINATEDNOW See what getting something like that in the UK would cost. Likely more than £500 with that much memory (street price of 4x32GB RDIMMS is about £400 here) but the shipping might be cheap enough to make a difference.

Thinking that myself... also, with SSD's for 256GB being cheap - maybe I'd be better off with an array of those? I'm firmly of the opinion that, apart from hobby... whatever, any real work from now on is on solid-state - spinning rust has hd its day!

Even 64GB with some sort of SSD RAID would be better? My own interest is PostgreSQL - and I believe that many of these servers would be mid-bracket in any case?

@Vérace-getVACCINATEDNOW ebay.co.uk/sch/i.html?_nkw=Intel+P4610

These are NVMe - you would need to get an adaptor card and cable for it.

Also, 2U machines are very noisy. Consider getting something like a HP Z440 or Z840 instead.

It's working with some sort of RAID framework that's of interest... AFK for a wee bit - taking walk with mother... thanks for your input - discuss later/some other time?

With NVME you probably don't need RAID.

Not for performance anyway.

RAID isn't just about speed - it's the reliability factor also?

For a dev machine I wouldn't spend real money for it.

And anyway, I want to get my hands dirty setting it up! :-)

You can certainly get small SATA or SAS SSDs cheap enough.

AFK... otherwise I'll never leave... :-)

OK.

@Vérace-getVACCINATEDNOW ebay.co.uk/itm/265524194816

This is a Z440 with 128GB of RAM and a 12 core CPU.

Not supported by Windows 11 but fine with Linux, Win10 or Windows Server 2019.

Get a RAID controller off ebay and an ICYdock to put 4 2'5" drives into the 5.25" bay.

Also functions just fine as a PC.

Much, much less noisy than a 2U server. Plus, the form factor is amenable to just putting under your desk.

@JohnK.N. The home page is nowhere near as bad as it was, but it's still a pretty big step backwards. Not looking forward to seeing more of it on \questions in particular

I suppose this was NOT the comment you twitted about ;)

No there's nothing visible

It's more of a general irk anyway

I do kinda get why people do it

I just wish they wouldn't

@paul and why do you think people do that? I don't have any theories, so I'm interested in yours