« first day (2092 days earlier)      last day (39 days later) » 

1:25 AM
Like a total n00b, I'm going to ask here, how do I edit this page (or any page in the tutorial etc)?
 
 
5 hours later…
6:25 AM
@AaronBertrand make a PR to the GitHub repo (like I did here for the tutorial: github.com/StackExchange/StackExchange.DataExplorer/pull/109) and then ask a dev, probably Adam, to merge to master and re-deploy. Allow for 6 to 8 weeks ...
I'm happy to make these changes for you as I have a local SEDE available so I can "test" changes before being pushed to the repo.
@rene going forward don't link to obscure commits / branches
 
 
6 hours later…
1:18 PM
@rene Thanks! This is useful. Do you have a link handy for the query you used to use to see the status of SEDE refresh?
I have so many tabs open that I really need to clean up today, trust me, it's faster to just ask you. :-)
 
You are speedy, thanks!
 
1:36 PM
0
A: How can one see when a query was cached in SEDE?

Aaron BertrandFor an answer to your direct question: How can one see when a query result was last cached in SEDE? One can't. This information is simply not exposed to SEDE. Cached plans and queries are cleared out during every refresh operation, so its age will always be 7 days or less (unless that specific...

 
 
2 hours later…
3:33 PM
I'll have to wait until next week to publish anything about eachdb.
@rene This just came up elsewhere and felt compelled to mention mssqltips.com/sqlservertip/7144/… / mssqltips.com/sqlservertip/7145/…
(Also in my defense I did not write the opening paragraph to part 1. I had to read it three times to understand it, and I'm not sure I succeeded.)
What you won't see on their site :-)
 
4:40 PM
@AaronBertrand I assumed the SQL team re-implemented FORMAT to be as performant as CONVERT but it look like they literally call out to the CLR. Lesson for today: Always Test for performance, even for things that come for "free" out of the box...
 
 
5 hours later…
9:54 PM
0
Q: Are SEDE results cached on client side, or solely on server side?

Franck DernoncourtI know that SEDE query results are cached on the server side. I wonder if in some cases they are also cached on the client side.

 

« first day (2092 days earlier)      last day (39 days later) »