> Are you sure that

Paul can’t escape it

It's an absolute curse

> I understand your explanation

Goes on to describe not understanding

Probably eats cheese from Trader Joe's

Locally sourced I’m sure

@PaulWhite yum

tastekapiti.co.nz/products/cheese.html

So is that like the real deal?

Yep

How's the ice cream tho?

My wife's very fond of deepsouthicecream.co.nz

Particularly the mochachino and double chocolate ones deepsouthicecream.co.nz/our-range#2-litre

kapitiicecream.co.nz/all-products?categories=ice-cream is also very good, but expensive

your basic tip top ice cream is also fine

there are any number of niche dairies out there making great stuff, but even supermarket blocks are perfectly good

@PaulWhite Looks good. Too bad it's so far away...

Also first time I've seen the metric system in the context of ice cream, totally throwing me off lol

Just divide everything by 13 fahrenseconds

Yea but 1 Bald Eagle = 1 Bald Eagle. 🦅 It's just easier the American way...

Easier if you're a USian, perhaps

On average, no one is

On average you aren't Paul White

But I guess Paul White is never average 🙂

I just checked, and using a 100% sample, I am.

who is the hero behind the mask

it's a real mystery

could be anyone, really

or no one

maybe it's ChatGPT come to replace the moderators

Ironically, a comment on an answer of yours

But yes, comment-answers is today's sock

Or this week's. They're sort of disposable.

Erik provided that originally, I think

heroes everywhere

Morning

Morning

The next gen web browser has no tabs, only spaces (Ep. 549)

This reminds me of the Charlieface's question from a few days ago

@PaulWhite How did you get this result, Paul? Is there a guide how to use a debugger?

According to my execution plans, there is no overhead when inserting either values into either column types.

@Zikato On that occasion, I stepped through the calls manually and kept a note of the order. There might be guides to using a debugger out there.

@Zikato My read of it focuses on the "code review". I think it's sloppy coding, but I don't know I'd make a fuss over it. Might be indicative of more usual sloppiness with data types.

I saw some difference when inserting 10 mil rows. But the call stack would be a definitive answer

DROP TABLE dbo.MyTable;
CREATE TABLE dbo.MyTable
  (
  CreateDate DATETIME2(0) NOT NULL DEFAULT GETUTCDATE()
  );
INSERT INTO MyTable (CreateDate)
VALUES
  ('2023-03-30 07:16:45.1234567')
  ;
INSERT INTO MyTable (CreateDate)
VALUES
  (GETUTCDATE())
  ;
INSERT INTO MyTable (CreateDate)
VALUES
  (SYSUTCDATETIME())
  ;
SELECT * FROM MyTable;

DROP TABLE dbo.MyTableFixed;
CREATE TABLE dbo.MyTableFixed
  (
  CreateDate DATETIME2(7) NOT NULL DEFAULT GETUTCDATE()
  );

INSERT INTO MyTableFixed (CreateDate)

brentozar.com/pastetheplan/?id=Bk7cOCz-h

@JohnK.N. No overhead? There an implicit conversion in both cases

[Expr1003] = Scalar Operator(CONVERT_IMPLICIT(datetime2(0),getutcdate(),0))
[Expr1003] = Scalar Operator(CONVERT_IMPLICIT(datetime2(0),sysutcdatetime(),0))

dbfiddle.uk/rOljSulf

@PaulWhite Is it possible to learn this power?

Right. One might expect changing the precision of an already datedate2 value to be faster than converting datetime to datetime2. But expectations don't always work out. For all we know, sysutcdatetime is implemented more efficiently than getutcdate. And I really don't think performance is the main concern here. I might be wrong.

@Zikato It must be.

knowyourmeme.com/memes/is-it-possible-to-learn-this-power

ah, of course

It'd be nice if the date/time intrinsics came with a precision specifier

Also write-once columns might be nice

CreateDate DATETIME2(0) NOT NULL
    GENERATED ALWAYS
    AS SYSUTCDATETIME2(0)
    READ_ONLY;

Something like that

Bit redundant in that case I suppose

even better if it was auto-named so you would have consistency across the tables

CreateDate, CreationTime, DateCreated, create_date, date_created, creation_time, CreationDate

You might collide with existing names though, I guess

That's a sacrifice I'm willing to make

Some of you may die

exactly

Allow us to mark columns as immutable or const

I've cast the upvote into the abyss

@PaulWhite Missed that.

Will add to answer.

Thanks.

It's ugly and I might delete it.

🔥🔥🔥

🎉🎉🎉

@JohnK.N. Morning! Unfortunately I only know one language, being an American and all, but I did watch it in its entirety and enjoyed. 🙂

@HannahVernon Noiceee 👏

Thx

@HannahVernon 🎈

@Zikato I wouldn't object if you had a go at answering.

goddammit

@JohnK.N. if I learn how to see the call stack, I'll have a go

Quite a quiet morning on the Stack so far.

I find it strange that even when inserting a valid datetime2(7) value, that it results in an CONVERT_IMPLICIT...

it has to get rid of the extra precision

Happens for this one too when inserting into the datetime2(7) defined column.

INSERT INTO MyTableFixed (CreateDate)
VALUES
  ('2023-03-30 11:24:03.123456')
  ;

[Expr1003] = Scalar Operator(CONVERT_IMPLICIT(datetime2(7),[@1],0))

Yes, it's converting from a string

INSERT INTO MyTableFixed (CreateDate)
VALUES
  (DATETIME2FROMPARTS(2023,3,30,11,24,3,123456, 7))

🤦🏼‍♂️

@Zikato Simple parameterization

INSERT INTO MyTableFixed (CreateDate)
VALUES ('2023-03-30 07:16:45.1234567')
OPTION (KEEP PLAN);

nothing simple about that parametrization

well done!

It's great when you get so many letters in the first word

Thanks! 🙂 For sure. I feel like there was a decent chance I could've gotten it in 2 guesses with that start if I grinded the brain gears, but I was still way ahead the rest of my family who were averaging 5 guesses today lol

awesome!

@Zikato I don't think people would input a date like that.

@HannahVernon Completely random fact, but I just realized you and Paul's timezones are exactly a half day apart lol. (Assuming he's in the GMT+13 TZ in NZ. Quite possible he's in the other one, idk.)

I guess that makes good shifts for mod coverage.

Aukland is 3:18am on Friday morning right now, and it's 9:18am Thursday here, so they're 18 hours ahead of us, but yes, it makes for good mod coverage when you consider that Paul only sleeps about 10 minutes a day (it seems)

I'm in US CDT timezone 👀

Oh perhaps my mistake. You're not in the UK?

@HannahVernon ahh

@J.D. you're in US EDT I'm guessing

Yuppers

I did my math right, but my premise was wrong. Womp womp.

it seems there is a Paulism for every occasion

Like XKCD or The Simpsons, but more refined.

@Lamak hey you got it, which is always good!

Kind of a fun design today.

@JoshDarnell asteroids!

Why isn't there a flag for "This comment should be an answer"

flag for a mod

i'm not sure this post lives up to its name

Let's make it easy! How to read System Health and sp_server_diagnostics?​

umm WHY THE HELL is the pseudocode I wrote for failover in that post?

The techcommunity posts by Juan Pablo Salgado Davila are now banned on Heap

@SeanGallardy there's a list of blog posts that were referenced at the end

@ErikDarling It's a direct copy and paste from a onenote page I made for HADR internals

not the whole post, just parts

(in 2016)

lol

hit JP up on teams

I did

now hit him in real life

Many more problems would be solved, faster, if that were possible

lol

The comments never disappoint: dba.stackexchange.com/a/325409/41723

lol

the gam interval question surprised me

i thought that was well known across the internet

@ErikDarling Same, it's quite easy to find without doing all that stuff. 1, it's documented. 2, a web search away.

Also, refresh that blog post, info is gone.

lol

bully

👊👊👊

@ErikDarling pew pew!

@JoshDarnell 💩💩