The Heap™ – Consultancy ©®

« first day (4287 days earlier) ← previous day next day → last day (880 days later) »

Paul White

01:30

@ErikDarling I understood that reference

4 hours later…

Paul White

05:35

Morning

Zikato

05:59

Morning

Vérace

06:13

A chairde - Morning all!

John K. N.

morning

John K. N.

06:52

One in the edit review queue...

dba.stackexchange.com/review/suggested-edits/187786

Any programmers in here? Is the edit reasonable?

> Edit summary: The point is to set the maximum length, not to use legacy non-Unicode encoding, so the example should not override nvarchar with varchar.

Paul White

@JoshDarnell Might know

John K. N.

trino seems to be a new thing.

Paul White

@JohnK.N. It's possible the varchar part of the answer relates to the OP's comment:

I know it does hurt performance. When I define my own tables with SQL I use varchar(n). My question was more about how much it hurts performance(though I realize as posted that wasn't explicitly clear). — Nate Aug 21, 2013 at 14:30

The answer seems consistent, without a strong reason to prefer the suggested change. I'd probably reject it. I'm prepared to be corrected by anyone who knows more about these things though.

John K. N.

07:34

Me three

Zikato

07:57

Last day in my current job

John K. N.

Angels ~~singing~~ rejoicing in the background: Hal-lelujah, hal-lelujah, hallelujah, hallejujah, hal--leee-luuuu-jahhhhhh

Zikato

08:14

Now, I've heard there was a secret chord.

John K. N.

08:27

When you debug something with a Microsoft Debugger, you require to have the Windows OS ..... and preferably the product ....

I can't remember the correct word. Not the signatures or libraries. The other thingy-ma-jig.

symbols?

Zikato

do you mean loading the symbols?

John K. N.

08:54

@Zikato yes, I think so. But you have to have them before you can load them.

Zikato

I think only some are public. But I'm out of my depth here

dezso

09:59

good morning

do you see any reason why Azure Synapse dedicated SQL pools are created with compatibility level 130 by default? why not 150?

also, what the gymnastics group thing is about? I've missed something, that much I get

Paul White

Dec 24, 2020 at 22:06, by Philᵀᴹ

Just wanted to take a minute to wish you and fam a very merry Christmas and a happy year, most of all good health!
These days people don't spend much time or thought on some personal words to their friends and family, they just copy and paste some random rubbish and send it on.
So, after all we've been though together this year I want to thank you for your friendship and support and wish you a happy 2021!
You are the best gymnastics group anyone could ask for.
Best wishes,
Phil

dezso

I've missed quite a lot, based on that date
and thank you very much indeed

Zikato

haha, perfection.

Zikato

10:17

Only 13 days for the Fanatic gold badge

Paul White

I wonder if visits to the site while suspended count toward that

Zikato

*sigh*. So close

Paul White

10:38

@dezso I know next to nothing about Synapse, but doesn't it use DW compatibility level instead?

docs.microsoft.com/en-us/sql/t-sql/statements/…

1 hour later…

ypercubeᵀᴹ

11:44

One more thing about this approach (as it is): it works if the IDs are consecutive and from 1 to N. If they are not (e.g. 2, 3, 7, 9) that will be updated to 4,3,2,1 (and not to 9,7,3,2). Not sure what the OP wants to do in that case, perhaps it's ok. — ypercubeᵀᴹ 43 secs ago

ypercubeᵀᴹ

12:30

@PaulWhite I'd like to see an answer with that "CTE (or subquery) update without updating the ID column and without a self-join"

Josh Darnell

@PaulWhite I would reject it too - and have! cc: @JohnK.N.

Seems weird to call varchar "legacy."

Zikato

Is varchar(24) also legacy?

Sean Gallardy - Mostly Retired

13:00

@Zikato (⓿_⓿)

ypercubeᵀᴹ

Is SQL Server 2022 going to support nth_value() window function ?

ypercubeᵀᴹ

13:25

dbfiddle.uk/WnG9XbSD for Paul, when he comes online

John K. N.

@JoshDarnell thanks

@ypercubeᵀᴹ I'm no good at creating dummy data for a PostgreSQL table. Would creating a 80 Million row / 8000 byte wide table required a lot of resources? And querying that table with a count(*) take a long time to run, say on db<>fiddle?

dezso

@PaulWhite that's an interesting question (haven't heard about this other compatibility level yet), however, the same page tells me 130 is not a valid option (only 10, 20, and 9000 are available)

ypercubeᵀᴹ

@JohnK.N. I wouldn't throw that much into dbfiddle

John K. N.

I could do it on a test instance at work.

ypercubeᵀᴹ

the count would be ok but inserting so much might be a problem. They run as VMs as far as I know

dezso

13:34

but at the same time ALTER DATABASE test SET compatibility_level = 150; says Incorrect syntax near '150'.

ypercubeᵀᴹ

Also consider that if you publish the link, every reuse will try to redo all the work.

Paul White

@ypercubeᵀᴹ no

John K. N.

@ypercubeᵀᴹ I'll plug it into a test database at work using How can I generate big data sample for Postgresql using generate_series and random?

Paul White

@dezso yes it's a different thing, a replacement if you will

@ypercubeᵀᴹ crikey I'm going to need to focus a bit on that one

@JoshDarnell thanks

Erik Darling

13:50

hello and good tidings

ypercubeᵀᴹ

@PaulWhite pity.

Postgres has the nth_value() but the update statement doesn't work the same, so we do need the join on PK in the final cte/query.

Paul White

14:08

@ypercubeᵀᴹ yes

@ErikDarling bon soir, mon ami

John K. N.

@ypercubeᵀᴹ well I just broke (as in filled up) my test instance with 80 Mio rows of random 4000 bytes per row of data.

dezso

anyway, Azure Data Studio tells me when opening the DB that it's at CL 130
probably I am not alone with being confused :D

John K. N.

ERROR:  could not extend file "base/17667/17669.8": No space left on device
HINT:  Check free disk space.

Paul White

@dezso Yes. With the caveat I have no idea about this, it seems to me the DW setting replaces db compat. level, or rather supersedes it. You can't set db CL, only the DW version. Synapse is built on a core shared with SQL Server, so bits show through. That's my opinion.

So, if you change DW, I would expect db CL to also change. 9000 => 160 perhaps.

But it's all a horrible mess, so I wish you the best of luck in your endeavours

dezso

14:26

thanks
TBH the docs (I mean, learns) are also terribly confusing, with about four slightly different products all documented in a single place. It's probably time to start from scratch, and call it something like msdntechnetbooksdoconline.microsoft.com

Paul White

It doesn't help there are two 'sections' for essentially the same thing

dezso

and that, indeed
and some links will navigate you from one to the other silently

Paul White

@dezso Check out this "explanation" What's the difference between Azure Synapse (formerly SQL DW) and Azure Synapse Analytics Workspace 🤡

dezso

my former boss was always complaining about AWS UX and the docs
I still should suggest him trying to work with Azure for a week or two, to raise his satisfaction level

Erik Darling

15:05

what is everyone doing this weekend

aside from being great

Paul White

thought I might go shopping for potassium iodide

stock up on canned food etc.

Erik Darling

15:22

aw, prepper paul

are you putin on a bbq

Paul White

old mate Jens is hosting this week, waiting for confirmation

Erik Darling

15:39

don't forget your spf

Paul White

Factor 5 million on order

Paul White

16:14

Jens can't make it. Stand down.

Zikato

For me depends on the weather. When nice, then we take the kids to the amusement park. I also want to finish a blog post series after a long pause.

Josh Darnell

My band has a gig tomorrow, so I'll be doing that for a big chunk of the day.

Paul White

16:30

@JoshDarnell Hurricane cancelled?

ypercubeᵀᴹ

16:52

@PaulWhite is there history for answers? Wondering if I can see when answer had been accepted (now it's unaccepted)

Paul White

@ypercubeᵀᴹ It's on the question's timeline as I recall

ypercubeᵀᴹ

ah great

Josh Darnell

@ypercubeᵀᴹ Not yet! The weather doesn't seem too bad after tomorrow morning here.

Paul White

@JoshDarnell Chat moved. You meant to reply to me, I think.

Josh Darnell

Of course, if power is out in the area, that'll do it.

@PaulWhite Oops!

ypercubeᵀᴹ

17:10

@PaulWhite it's not but ok, I found it in my rep history.

4 hours later…

ypercubeᵀᴹ

20:58

@PaulWhite simplified a bit: dbfiddle.uk/pFezY1Kx

ah, it's not correct (the simplified version). too good to be true :(

Erik Darling

have you tried being correct?

ypercubeᵀᴹ

21:21

Yeah. I think I fixed it: dbfiddle.uk/SUUeK3UB

2 hours later…

Paul White

23:45

🤔

« first day (4287 days earlier) ← previous day next day → last day (880 days later) »

all rooms

Transcript for

Sep29

Sep '2230

Oct1

General on- and off-site discussion for dba.stackexchange.com....

frogs mysql nosql oracle postgresql sqlite sql-server

join this room
about this room

00:00

06:00

12:00

18:00

all times are UTC