« first day (4239 days earlier)      last day (55 days later) » 

1:17 AM
@Vérace-СлаваУкраїні I actually like Evan, we're friends on Facebook. I think he likes to stir up tech folks.
 
 
6 hours later…
7:00 AM
A chairde - Morning all!
@HannahVernon I know him from other forums (PostgreSQL) - he's very able and helpful and, as I said, a loss to these database fora, both chat and main! I think I should have put a smiley after the "Trolls 'R Us!" bit - could you edit one in for me please?
@ypercubeᵀᴹ Not quite sure I get this - no doubt, I'd be bent double if I did! :-)
 
 
3 hours later…
9:57 AM
Hey everyone have a great weekend
 
10:16 AM
@PaulWhite looks like a lawsuit
 
doesn't everything
@ErikDarling btw in case you missed it & have interest dba.stackexchange.com/a/315538
 
nifty
bit funny how a half-assed question yielded so many answers
 
it's hard to predict which questions will engage people
there must be a million-and-one special schemes for this type of problem
 
I've even seen ideas based on spatial before
 
10:28 AM
your setup is also v. unfair to me
all type ids are 2!
oy
 
yes it's deliberately similar to Joe's unfair distribution, but with the ability to repro
on the flipside, it's quite likely people would want to search for close-to-recent date ranges in a large archive table
 
😤😤😤
 
so I don't think it's entirely unreasonable
 
sounds unrealistic
 
well it probably is, given a sensible design, but who has one of those
you'd archive off old rows to another table, for example
 
10:31 AM
i'll archive you off
meanie
 
your generally-useful index is still way better than the original even in the worst case
and doesn't require a memory grant
 
or an indexed view
which i hear are bad for performance
 
indexed views are perfect and lovely in every respect
 
adam used to moan about maintenance on those quite a bit
 
he's a moaner though
 
10:33 AM
said it was impossible to maintain them when they're attached to billion row tables
 
a well-implemented indexed view is hardly more expensive than a secondary index
 
he also said he hasn't found a good use for batch mode yet too though, so maybe postgres is really getting to him
 
he'll be fully on-board when Postgres invents batch mode in 2050
but anyway, it's like anything else, indexed views are a good solution when they're a good solution
 
so good when good, bad when bad
 
pretty much
great when cost < benefit
better than a 2.5GB index on a 1GB table for example
 
10:38 AM
how did that happen
 
well the 2.5 index is uncompressed and the computed column essentially duplicates the datetime column
the computed column isn't persisted, so takes no space in the base
 
unafair(max)
 
shenanigans
like all specific optimizations
 
ha ha
i see there's no memory grant column in your final analysis either
getting sloppy
or is this just more moderator oppression
 
honestly I considered it but cnba after rebuilding all those indexes at three different compression levels
also markdown tables aren't as fun as they look
 
10:45 AM
that would make a great bank name acronym
2
or isp
 
wouldn't it
 
anyway you can expect the fbi at your house
post haste
 
luckily I live in freer country
but yeah anyway the details would be endless like sneaking in bmor and top n sorts being quicker <= 100 etc etc etc
 
yeah
 
generally quicker, anyway
 
10:49 AM
i believe joe got a window aggregate
 
long, similar keys in exactly reversed order aside
@ErikDarling yes and the final top n sort is also batch mode
not that it's important
 
wild nights are calling
 
how long do you have left in the land of the canaries?
 
i think we leave for lisbon on tuesday
 
I liked Lisbon
Wouldn't necessarily go there on holiday
 
10:51 AM
would you like to go to lisbon on tuesday
for work, obviously
so i can write it off
 
ha ha you're so american
did you know that
 
vicious rumour
 
but yeah I'd love to fly for 30 hours so you can get a tax break
 
what a pal!
 
😎
 
10:53 AM
we're visiting the ozar porsche ranch in november before pass
 
for work, obv
 
yeah we're gonna live blog the whole thing
 
if polio doesn't get you first eh
I'm slightly bothered by the Peter Gabriel reference
Was it from his time in Genesis, or solo?
 
i've never cared for ralph lauren
 
ha ha
 
10:58 AM
@PaulWhite from the gif?
 
@ErikDarling yes
I sort of mentally went with Land of Confusion
But who knows with you
Luckily there's no requirement to explain jokes at great length on tweeter
 
well the gif is a reference to the movie say anything which has in your eyes on the soundtrack
 
crikey
 
but really i was just looking for something that conveyed nonchalance
 
you're like the da vinci code some days
Erik's level: population 1
 
11:02 AM
i am often compared to vitruvian man yeah
 
where do you keep the extra arms and legs
 
they just move so fast it looks like i have two of each
 
ah
I've never seen Say Anything so that prolly didn't help
Looks like a chick flick
 
> The maximum space for tempdb depends on the selected service tier of the database. When changing the service tier, you can either scale to a higher level within the same purchasing model or consider moving to another purchasing model.

For databases in the DTU model, the range is between 13.9 GB and 384 GB (Basic to Standard S12), and is 166.7 GB in Premium. In the vCore model, the range is between 32 GB and 4096 GB, depending on the hardware platform and if using General Purpose vs. Business Critical.
I hadn't appreciated how miserably small tempdb was in the cloud
Anyway it seems the good news is one can spend more money
@ErikDarling I'll czech it out
Will never tire of that gag
 
11:57 AM
@PaulWhite if I’m reading this right, for more money they let a senior DBA set up tempdb.
 
intern-al details
 
Can you summerize them for me
 
"regarding"
a larger summery is available at higher subscription levels
 
12:39 PM
The ol’ 100 row table variable meme strikes again
 
the whole post is a meme
but at least the author provided their pronouns
 
Well yeah
 
oops I mean his pronouns ofc
nice of them him to provide the three different forms hope that didn't take too much space in his tempdb
 
Yes it’s quite clear we need to say he is an idiot and his post is a meme and I wish him a long career on the SharePoint team.
 
🤣
 
12:49 PM
@Vérace-СлаваУкраїні your wish is my command
 
perhaps Cole will add a third emoj
 
Lol
I like the clown btw
 
it's very cute
MemeDB logo
 
Quite apropos
 
12:53 PM
perfectly normal country being perfectly normal
perhaps they'll get tanks too
 
"The report said the agency also purchased “hitman suits," though no explanation was provided."
I wanna know if they're trained to say "say what again" every time a perp says "what"
 
ha ha ha
sounds like a gr8 job anyway
50 hours per week minimum, on call 24/7
might get shot
 
also illustrates the hitman suits
 
Quite nicely
 
1:40 PM
Wonder who they think they’re busting
 
Tax exiles in Mexico and Lisbon perhaps
 
1:53 PM
They’ll never find me in New Zealand then
 
I suppose it depends how they distribute the 87,000 new agents
and maybe how the kim.com case eventually turns out
not about tax per se but same vibes
presumably the IRS plan to turn a profit on that $80bn 'investment'
 
2:31 PM
not from me
i'm gonna spend it all on wine exports
 
oh well you'll be fine then
...
 
send the bill to sam neill
 
@UshbyTechnicalTeam Well what Paul said but I was trying to phrase it nicely since you're a new user. — Erik Darling 6 mins ago
 
@PaulWhite quite an odd response that was
 
very welcoming
grrr
 
2:34 PM
woah
time warp
 
eventually consistent
 
mongoose
 
let's mongooooo!
 
i am getting a swedish massage tomorrow
for 55 european minutes
 
2:52 PM
Well I hope he's gentle with u
 
i don't
 
The customer is always right
 
I am not editing anything, the concept should not just be tool boxes that you use, but ideas. — Ushby Technical Team 3 mins ago
hoowee
 
feisty
a bold strategy
v bold
 
well as soon as microsoft implements their ideas it will be a correct mediocre answer
eventual mediocrity
 
3:04 PM
and if there's one thing this site needs, it's more mediocrity
 
oh am i becoming a featured blogger here
cool
 
Your comment is very fixed, we have to be lenient, to other approaches and abilities in order to achieve the same goal, why down-vote if it never harmed anyone but only opened doors for people to do what they want with their businesses, you are crucial sir, and don't tell me it has nothing to do with this stack, everything is connected in a way, I am not talking about pork stakes. — Ushby Technical Team 51 secs ago
Do we have any experts on pork stakes around?
I might start answering Oracle and DB2 questions with SQL Server answers in a Zen way
Or I might become a vampire pig
 
doesn't sound like it would jive with vegetarianism
 
good point (on your stake)
 
i ate a magyar steak last night
it tasted like it had a nice life
 
3:18 PM
First happy ending of the day then
 
everyone at this hotel is from the uk
 
Well you are in Portugal, what would you expect during the British summer
 
even the guy in a barcelona hat and t-shirt is from manchster
 
@PaulWhite awkward turnaround: the OP edits the question and changes [sql-server] to [mysql] tag ;)
 
@ypercubeᵀᴹ ha ha nothing would surprise me at this stage
 
3:20 PM
OP changes the site URL to wordpress.stackexchange.com
we all burn
 
@ErikDarling are they talking very loudly and putting an O at the end of each word to be better understood, while demanding a proper Full English Breakfast and nine beers?
Not to stereotype anyone
 
i should take a picture of the breakfast buffet tomorrow
you can basically serve yourself a full english
 
falls over in shock
 
i've only ever seen setups this specific at uk airport lounges
 
know thy customer
Eldorado (En: “The Golden”) was a British soap opera created by Tony Holland from an original idea by John Dark and Verity Lambert of a glamorous, upmarket soap focusing on wealthy British expatriates similar to US soaps Dallas and Dynasty. The show ran for only one year, from 6 July 1992 to 9 July 1993. Set in the fictional town of Los Barcos on the Costa Eldorado in Spain and following the lives of British and European expatriates, the BBC hoped it would be as successful as EastEnders and replicate some of the sunshine and glamour of imported Australian soaps such as Home and Away and Neighbours...
 
3:23 PM
@PaulWhite yes, and everyone has a gold right canine tooth and a missing left canine tooth
 
perfect
bruv
 
everyone says "for pete's sake" quite a bit
 
have you been recolonised yet
started using unnecessary Us or anything
ha Kimberley Tripp liked my HOLDLOCK rant
 
houldlouck
ohno
 
there ya go
 
3:28 PM
this seems to be the only beer legal on the island
 
What even is that and when did Portugal move to the Tropics
Oh you're not there yet
Still
 
still a canary
also weird, i haven't seen a single canary
 
demand a refund
 
but there is one cat that hangs out at the hotel
 
3:31 PM
competing interests
 
🤔
 
is this like that griddb guy
 
variation on a theme perhaps
 
also i can't help but unscramble that to bushy
quite something
 
do you have a bushy plan for today
perhaps that'll be fixed as part of the massage
Buzby was a yellow (later orange) talking cartoon bird, launched in 1976 as part of a marketing campaign by Post Office Telecommunications, which later became British Telecommunications (BT). == Overview == Buzby appeared in a series of television commercials with the catchphrase: "Make someone happy with a phone call". Buzby's voice was provided by Bernard Cribbins, and the character was animated by Charlie Jenkins of Trickfilm Studios, London.The campaign spawned many marketing items, such as toys, badges, a comic strip in TV Comic, and books, and lasted until well into the 1980s. British Telecom...
it's all connected to canaries
 
3:54 PM
@PaulWhite that's an awfully personal question
 
feels like unravelling a massive conspiracy here
 
 
1 hour later…
4:54 PM
@HannahVernon Thanks - appreciated. I'd hate to think that our mutual friend thought that I was slagging him! :-)
 
5:23 PM
The pool bar at this hotel keeps playing this Erasure remix
It’s painful
 
 
1 hour later…
I wonder if it will
 
6:48 PM
Sinkhole raids White House
 
 
2 hours later…
8:31 PM
Why is this site suddenly anti lingonberry
 

« first day (4239 days earlier)      last day (55 days later) »