« first day (4993 days earlier)      last day (87 days later) » 

12:37 AM
@PaulWhite That's too much to keep tabs on
 
6 hours later…
6:13 AM
Wordle 1,174 4/6*

⬛⬛🟨⬛🟨
⬛🟩⬛🟩⬛
🟨🟩⬛🟩⬛
🟩🟩🟩🟩🟩
 
3 hours later…
9:29 AM
Wordle 1,174 4/6*

⬛⬛🟨🟨⬛
🟩⬛⬛⬛🟨
🟩⬛⬛🟩🟨
🟩🟩🟩🟩🟩
10:15 AM
1
A: Does SQL Server support GREATEST and LEAST, if not what is the common workaround?

Ed AvisUser-defined functions I create user-defined functions, e.g. create function dbo.udf_LeastInt(@a int, @b int) returns int with schemabinding as begin return case when @a <= @b then @a when @b < @a then @b else null end end sql_variant You can also make on...

Expanded this answer
 
2 hours later…
12:44 PM
That’s a lot of charity work
Did you win lotto
1:22 PM
I wish
totally unrelated; been reading some community bot pushed questinos 🤮
Well, they get bumped because no one's done anything with them
Doing something to them will fix that
1:43 PM
Is Nga Wai hono i te po Paki well known in Aotearoa?
 
1 hour later…
2:54 PM
Not to me
 
2 hours later…
4:34 PM
I’m stuck in traffic going to the airport
Can anyone spare a cigarette
4:48 PM
Thank you
If you're in NYC traffic then you'll need a pack
Good thinking
I used to have entire conversations on the phone with people for the drive from the airport to the hilton by Trinity in downtown manhattan
Took an hour or more sometimes
if you fly into Newark the helicopter into midtown is only like $50 more than a cab
probably not the best place to hold a conference call though
on the other hand the bus is like $10 and takes the same amount of time as the taxi
takes all kinds i suppose
5:39 PM
The drive from me to Newark is a lot better than to LGA, but the flight schedules aren’t always as good
6:21 PM
Azure users deserve to have problems
3
can't use indexed views... can't use Azure...
is this the inevitable evolution of @Z into a linux user?
have the pings driven him mad?
@Zikato would like everyone to sit around using on-prem service broker and nothing else.
6:35 PM
You can use anything you want. Erik's rates are reasonable
4
@ErikDarling I got burned by that on a SQL Server 2014 instance a little while back.
Or maybe it was 2012.
It was real old.
The EF team is sort of backing off of that JSON thing.
Aug 20 at 14:30, by Paul White
> In 8.0, we changed the default translation for parameterized lists from constantization to parameterization (e.g. with OPENJSON); this is better for plan/query caching (single SQL), but can produce bad query plans (#32394). For 9, we're adding extensive means to control the parameterization vs. constantization behavior, both at the global context options level (#34344) and at the per-collection level (EF.Constant, EF.Parameter (#34345)).

For 10, we plan to reexamine what the default should be. The problem with the current full parameterization, is that the bad plans it occasionally cause
7:26 PM
I wonder what version will allow using temp tables
8:04 PM
It has been discussed and discarded as an idea
SSMS bike shedding continues
8:30 PM
Why are they trying to get rid of bikes
Did they buy AdventureWorks assets at auction
9:02 PM
@ErikDarling It's seasonal

« first day (4993 days earlier)      last day (87 days later) »