« first day (3306 days earlier)      last day (30 days later) » 

6:46 AM
@CadeRoux I know very little about SSRS but the manual page referenced by your first link says at the beginning, 'The Reporting Services RsReportServer.config file stores settings that are used by the Report Server Web service and background processing.' I would think that means the settings in this file shouldn't apply to your own application, but I may be wrong.
Morning
 
 
1 hour later…
8:06 AM
Morning
 
 
1 hour later…
9:22 AM
Morning All...
for those who remember me talking about database of databases....
I thought about it further, I want to create a database of world
Think about it whatever we humans store in brian in regards to entities and relationship between them
e.g. we know what a order is, what attributes are related to it and what relationship it has with other objects...
I want to start a generic open database of such objects, there properties and there relationships with each other
use cases could be enormous but one of them could be generating SIMPLE CRUD applications just by selecting your objects or entities and
I would be surprised if there isn't one already
 
It sounds very ambitious, and I personally think it would be the first one of this kind. I'm still not sure I understand how it could be used, though.
 
I came across this book review, and just wondering if people had an opinion about this book.
 
10:12 AM
@Mathematics But do we really know what an order is or what attributes are related? I mean doesn't that change with personal interpretation and cultural background and what not?
Maybe I'm just not following where you are going
but a database of "everything" probably doesn't exist yet
 
 
1 hour later…
11:38 AM
@FaheemMitha should be good. It's on my to-buy list ;)
 
@ypercubeᵀᴹ Ok. So DBA do buy DB books?
 
yeah, sure they do
 
We have shelves full of unread books
 
Literally
 
11:57 AM
 
12:16 PM
@Johnakahot2use Those are definitely all unread (by me at least)
 
@Johnakahot2use that looks like a shelf from the 200x decade ;)
 
If you know the basics....
 
It's sooooo 2007
 
1:33 PM
@AndriyM That's what I'm thinking. So it seems like it's only specifiable in the RDLs or it falls back to 30s. I have some queries that take a couple minutes to run and they need indexes I have designed, but service updates to the app have to go through potentially months of approval for release because of FDA and other process restrictions, so I has hoping there was an overriding setting in SSRS, but it looks like we could just update affected RDLs until people get the indexes.
 
1:47 PM
@CadeRoux Sorry, I'm totally new to all this, but I'm guessing an RDL is a piece of source code you can change easily enough? I mean, more easily than the application(s) affected by this issue (assuming timeout can be set in the application code as well, that is)? With what we are using here, if a query starts timing out and we need to increase the timeout until we sort out the problem with it, we have to change the application code.
 
2:02 PM
@TomV-trytopanswers.xyz subtitles has nothing to do with what he is saying!!
 
@AndriyM RDL is the standard file extension for SSRS report object source code. it's XML under the hood. IIRC, there's a whole bunch of different places to set timeouts for various granularities based on various conditions
both in the report / RDL itself, in various dependent objects ( embedded datasources / datasets / nested reports ), and above that at the service level & config
all the options
 
I like flexibility in general but this sounds a little maintenance-unfriendly on the surface, to be honest
 
lol, it is what it is. my experience was that it's too easy to use, so you do end up shooting yourself in the foot a lot
 
Yes, that's the right metaphor
 
but it's got a lot of self-service support, so that's kind of the price of entry
 
2:21 PM
@McNets I think it's the demeanour, not the spoken language, that sells the message in the subtitles to the non-Spanish speaking world
 
@AndriyM This particular system is an analytics database related to an operational database with some SSRS reports as well as some ETL-style processes managed by a DLL that the operational data calls when a physician signs a cardiovascular study. One of the things I'm trying to do is improve the performance of a variety of queries.
Unfortunately, most schema changes are tightly controlled due to the healthcare environment, and I'm hoping to get the index improvements treated a little bit more streamlined and leniently. Changes to the RDL are less strictly controlled - BUT each RDL file would have to have a <Timeout> element added to the <Query> element.
As far as I can tell, there is no fallback to a higher level of timeout if you leave it out of the RDL. That's the query timeout - because reports can have quite complex pagination and logic, there is also report overall "processing" timeouts - and I think this IS settable at a few different levels.
 
2:36 PM
@CadeRoux Even though I don't understand quite all the details, I've understood enough to get my answer, thanks.
 
> Thank you for reviewing 20 close votes today; come back in 9 hours to continue reviewing.
 
@AndriyM yes I know, just pointing it out
 
Can moderators interact with users? This user might want to read the "Help Center" a bit. His questions are, .... well how do I put it without being unwelcoming?
 
2:59 PM
@McNets It's something about the cucina and the playa
 
@TomV-trytopanswers.xyz He was a peculiar character time ago, he appeared in some TV shows for a while. And yes he is talking about something that happened in a restaurant in front of the beach between low and high tied.
 
I can see why they wanted to put him on shows
I can think of less funny people on TV
 
@TomV-trytopanswers.xyz in fact, as @AndriyM has pointed out, it's all about his demeanour, He used to explain things in a funny way.
He was known as the-brother-in-law
 
3:34 PM
@McNets His clips got famous all over the world with incorrect subtitles.
 
 
2 hours later…
5:43 PM
@TomV-trytopanswers.xyz this deserves 11 stars! At least.
 
 
1 hour later…
DRP
7:07 PM
Hi Team, a table Person has an attribute of gender. So for the gender table my thought is that it is a strong relation (non-dashed) , because without the person there can be no gender, is this train of thought correct?
 
7:28 PM
@DRP If the gender is in the same table, is there even a relationship?
 
DRP
8:12 PM
I get your point, in that case there is no purpose for a gender relationship. I guess PHYSICAL_CHARACTERISTICS would represent more a relationship, which in that case would be strong right?
Because for example my understanding is that the attribute i.e Gender, come with the Person when the person is born, and for example an email is something that the person can decide to obtain later on and hence a separate table would be represented
Physical characteristics do tend to change over time
Obviously I'm learner here...
 
Gender, come with the Person when the person is born You risk running afoul of the new code of conduct here
@DRP Relationships are between entities. If gender or physical characteristic are proper entities in your model of the world, then you can immediately decide what kind of relationship they have. If they are attributes, they don't have a relationship.
 
 
1 hour later…
9:33 PM
11
A: What is the `TABLE example` syntax called?

a_horse_with_no_nameIt's documented with the SELECT statement and it's called "TABLE Command" there. In the SQL standard it's called an "explicit table": The <explicit table>    TABLE <table or query name> is equivalent to the    ( SELECT * FROM <table or query name> ) This seems to be part ...

TIL
also @Jacksaystrytopanswers.xyz - i'm loving the realization that the same batch(es) on db<>fiddle between different engines keep the same "batch-hash" & just change the engine param, but i'm wondering how the caching works for synonymous batch UUIDs 🤔
in any case, for batch-hash `c079fd93baf741edc88ceb2943921176`, it looks like the explicit table syntax is supported in
* [mysql](https://dbfiddle.uk/?rdbms=mysql_8.0&fiddle=c079fd93baf741edc88ceb2943921176)
* [postgres](https://dbfiddle.uk/?rdbms=postgres_12&fiddle=c079fd93baf741edc88ceb2943921176)
but not in
* [sql server](https://dbfiddle.uk/?rdbms=sqlserver_2019&fiddle=c079fd93baf741edc88ceb2943921176)
* [sqlite](https://dbfiddle.uk/?rdbms=sqlite_3.8&fiddle=c079fd93baf741edc88ceb2943921176)
 
10:34 PM
@DRP gender doesn't belong in any database, unless it's a free-form text field of varying length at least 50 characters. I'd tend towards not including it unless strictly required by law.
 
11:09 PM
We have need for sex at birth in cardiovascular DB.
It affects whether a particular part of the heart or vessel is on the small or large side for a person.
Having said that, it's still nonbinary. I assume people that are not Male or Female in that just end up getting left out of most analysis and may very well miss out on automated highlighted treatment recommendations if their findings don't end up in range for particular FDA approved criteria for certain procedures.
I don't know what the answer is. If you identify as a woman but could benefit from a certain kind of valve replacement recommended for men over 50 because of your physiology, I don't know how we can do more than hope the doctor knows enough to check all those ranges manually, because you won't show up on a report.
 

« first day (3306 days earlier)      last day (30 days later) »