« first day (4259 days earlier)      last day (908 days later) » 

Paul White
Paul White
02:05
Luckily it's documented
> SET @variable = column = expression sets the variable to the same value as the column. This differs from SET @variable = column, column = expression, which sets the variable to the pre-update value of the column.
docs.microsoft.com/en-us/sql/t-sql/queries/update-transact-sql
It's a behaviour from the dinosaur days. If you were implementing it today, you'd probably use the inserted and deleted syntax
mustaccio
mustaccio
Oh oh Paul remembers dinosaurses
Erik Darling
Erik Darling
03:13
Paul remembers when God walked on Earth
Perhaps you’re unfamiliar with his origin story as an intergalactic celestial being
God was a toddler then, just really liked the idea of big green things saying RAWR
By then Paul was firing up the debugger to find trace flags that turned dinosaurs into birds
 
2 hours later…
John K. N.
John K. N.
05:38
😂😂
Morning
Zikato
Zikato
Morning
John K. N.
John K. N.
I use "PicPick" for screen shots. Similar feature set. Wanted to leave a comment on your blog but....
user image
Act on my behalf? Nah, I'll pass.
Zikato
Zikato
06:00
Yeah, I had this conversation with Paul as well. I think it's poorly explained from the GitHub and the developer doesn't have more granular permission
Act on your behalf
> The application may need to perform tasks on GitHub, as you. This might include creating an issue, or commenting on a pull request. This ability to act on your behalf is limited to the GitHub resources where both you and the GitHub App have access. In some cases, however, the application may never make any changes on your behalf.
docs.github.com/en/authentication/…
So since the App only has permissions on my comment repo, it can only post there.
Zikato
Zikato
06:46
Yesterday I was introduced to GB vs GiB
Paul White
Paul White
07:14
One means Great Britain, the other is a type of internal plasterboard
HtH
John K. N.
John K. N.
07:31
@Zikato 1000 vs. 1024?
Paul White
Paul White
yes gibibyte etc
Paul White
Paul White
07:49
@Charlieface Do you mean this statement? 
UPDATE [Table]
SET
[Flag] = 1
WHERE [ID] = (SELECT MAX([ID]) FROM [Table] WHERE [Name] = 'DEV')
Zikato
Zikato
08:09
Yes, I was sheltered within a Microsoft environment where it's always 1024. But I had to choose the correct one from Grafana which supports both standards.
IEC = GiB and SI = GB
Paul White
Paul White
08:30
If so, then the transformation you're after is GenGbApplySimple
The Segment operator is only needed when there's a grouping component. It turns this:
user image
into this:
user image
Paul White
Paul White
08:44
I don't know if that answers your question exactly.
The index seek on name is already present, for example.
17 hours ago, by Charlieface
SQL Server never combines a self-join into a single lookup, right? Apparently it does sometimes https://dbfiddle.uk/?rdbms=sqlserver_2019&fiddle=560f1c0837dd61160cefea1feb83a50f
So I guess it depends what you meant by "combines a self-join into a single lookup". 
UPDATE dbo.[Table]
SET Flag = 1
WHERE dbo.[Table].ID =
(
    SELECT MAX(T2.ID)
    FROM dbo.[Table] AS T2
    WHERE T2.[Name] = dbo.[Table].[Name] -- grouping
);
produces:
user image
with a 'segment top'
Charlieface
Charlieface
09:35
@PaulWhite Yeah that was it. I knew it had to be a special-cased rule, because it was too complicated to fit into any of the obvious ones like foreign-key join elimination.
 
4 hours later…
Josh Darnell
Josh Darnell
13:30
I would take 'kibibyte' more seriously if it didn't sound so much like 'Kibbles N Bits'.
2
mustaccio
mustaccio
13:59
From an internal chat:
> we should make the emoji for invoicing
Charlieface
Charlieface
"Should array indices start at 0 or 1? My compromise of 0.5 was rejected without, I thought, proper consideration." — Stan Kelly-Bootle
Erik Darling
Erik Darling
14:51
🧾
mustaccio
mustaccio
15:35
It finally has come to that... I've been officially asked by my boss to blog.
Zikato
Zikato
food or travel?
mustaccio
mustaccio
16:20
"Architecture" and "cloud" were mentioned, so I guess travel. Though we have no travel budget. I'll need to watch some Youtube videos.
Paul White
Paul White
@JoshDarnell Oh that's great I hadn't seen that before
The standards xkcd could also apply xkcd.com/927
Charlieface
Charlieface
17:13
So I made some reasonable comments about how to improve this answer, which has 296 votes and is the highest voted answer for this type of question, and got no repsonse. A while later I just make the modifications, assuming OP had abandoned it. Then they all get rolled back!?
296
A: SQL Server dynamic PIVOT query?

TarynDynamic SQL PIVOT: create table temp ( date datetime, category varchar(3), amount money ) insert into temp values ('1/1/2012', 'ABC', 1000.00) insert into temp values ('2/1/2012', 'DEF', 500.00) insert into temp values ('2/1/2012', 'GHI', 800.00) insert into temp values ('2/10/2012',...

Yeah, I know this is a Stack Overflow post, but don't want to deal with the flaming mobs over there
Paul White
Paul White
@Charlieface Seems she didn't like your edits. BTW in case you are unfamiliar, Taryn was a regular here, then a Community Manager, then SO DBRE, now at Microsoft.
She also makes chopping boards.
So what's the reason for the rollback? Are these not good improvements? — Charlieface 2 days ago
You've already commented so there's not much more to be done there.
Paul White
Paul White
17:39
The proposed edits seem useful to me on a first read.
It's not a perfect system is it.
Charlieface
Charlieface
18:01
@PaulWhite Question is: who owns such a highly upvoted answer on such a well used post? It really should be a wiki, it's the canonical post for that question. If someone else would roll it forwards again, we might get somewhere
Paul White
Paul White
That's why I say the system isn't perfect. The original author gets the tie-breaker in most cases.
In Defense of Editing
Jeff Atwood on April 08, 2009
Editing is the backbone of Stack Overflow, and probably (along with the reputation system) one of the single most important distinctions between Stack Overflow and “just another forum”. What’s so special about editing? You might as well ask what’s so special about editing on Wikipedia? Uh… everything? As it says in the FAQ: Other people…
That advice is generally still pretty sound
Unless Taryn rolled back until she has time to sufficiently consider your edits, I'd say your only option is to add an answer of your own.
And to be fair, the edits are quite minor. Good and more modern practice perhaps, but unlikely to be important to the performance of constructing the column list. Adding a variable for a separator that can only be a comma in context is pretty dubious.
ypercubeᵀᴹ
ypercubeᵀᴹ
19:02
my luck at travelling continues with huge success
I am now in a Geneva hotel, instead of my home ;)
3
@PaulWhite not to mention running cross-fits
And speaking of edits, I am tempted to rollback this one (or most of it): dba.stackexchange.com/posts/316373/revisions
Vérace
Vérace
Bonnes vacances alors a Geneve!
ypercubeᵀᴹ
ypercubeᵀᴹ
If it was Zurich, we could have a Heap meeting !
Vérace
Vérace
Nicht wahr?
ypercubeᵀᴹ
ypercubeᵀᴹ
@Vérace pardon?
I didn't mean you @Vérace
@JohnK.N. lives near Zurich I believe.
Vérace
Vérace
St Gallen?
ypercubeᵀᴹ
ypercubeᵀᴹ
19:12
gbn is also in Switzerland but I don't have more exact location!
Vérace
Vérace
Still in Dublin here - never been to Switzerland - I would like to go - I find the canton system interesting to read about. James Joyce is buried in Zurich!
Peter Vandivier
Peter Vandivier
19:59
@ypercubeᵀᴹ if nothing else, properly escape the * character, unless 156 really does = 30
in which case this Dewi fellow has some very intriguing math
 
1 hour later…
ypercubeᵀᴹ
ypercubeᵀᴹ
21:03
@PeterVandivier yeah, that needs correction. I was annoyed by the "FOREIGN KEYS are irrelevant". Which they may be, from a certain point of view. But not from the OP/question's.

« first day (4259 days earlier)      last day (908 days later) »