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

Andriy M
Andriy M
06:46
@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
Tom V - try topanswers.xyz
Tom V - try topanswers.xyz
07:01
m
 
1 hour later…
McNets
McNets
08:06
Morning
 
1 hour later…
Mathematics
Mathematics
09:22
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
Andriy M
Andriy M
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.
Faheem Mitha
Faheem Mitha
I came across this book review, and just wondering if people had an opinion about this book.
julien.danjou.info/the-art-of-postgresql-is-out
Tom V - try topanswers.xyz
Tom V - try topanswers.xyz
10:12
@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…
ypercubeᵀᴹ
ypercubeᵀᴹ
11:38
@FaheemMitha should be good. It's on my to-buy list ;)
Faheem Mitha
Faheem Mitha
@ypercubeᵀᴹ Ok. So DBA do buy DB books?
ypercubeᵀᴹ
ypercubeᵀᴹ
yeah, sure they do
Tom V - try topanswers.xyz
Tom V - try topanswers.xyz
We have shelves full of unread books
John aka hot2use
John aka hot2use
Literally
George.Palacios
George.Palacios
@Johnakahot2use that word has no meaning anymore :(
https://www.google.com/search?{google:acceptedSuggestion}}oq=define%3A+literally&sourceid=chrome&ie=UTF-8&q=define%3A+literally
John aka hot2use
John aka hot2use
11:57
user image
Andriy M
Andriy M
12:16
@Johnakahot2use Those are definitely all unread (by me at least)
ypercubeᵀᴹ
ypercubeᵀᴹ
@Johnakahot2use that looks like a shelf from the 200x decade ;)
John aka hot2use
John aka hot2use
If you know the basics....
Andriy M
Andriy M
It's sooooo 2007
Tom V - try topanswers.xyz
Tom V - try topanswers.xyz
12:47
current status
Let's deploy to production
►
8
Cade Roux
Cade Roux
13:33
@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.
Andriy M
Andriy M
13:47
@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.
McNets
McNets
14:02
@TomV-trytopanswers.xyz subtitles has nothing to do with what he is saying!!
Peter Vandivier
Peter Vandivier
@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
Andriy M
Andriy M
I like flexibility in general but this sounds a little maintenance-unfriendly on the surface, to be honest
Peter Vandivier
Peter Vandivier
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
Andriy M
Andriy M
Yes, that's the right metaphor
Peter Vandivier
Peter Vandivier
but it's got a lot of self-service support, so that's kind of the price of entry
Andriy M
Andriy M
14:21
@McNets I think it's the demeanour, not the spoken language, that sells the message in the subtitles to the non-Spanish speaking world
Cade Roux
Cade Roux
@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.
Andriy M
Andriy M
14:36
@CadeRoux Even though I don't understand quite all the details, I've understood enough to get my answer, thanks.
John aka hot2use
John aka hot2use
> Thank you for reviewing 20 close votes today; come back in 9 hours to continue reviewing.
McNets
McNets
@AndriyM yes I know, just pointing it out
John aka hot2use
John aka hot2use
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?
Tom V - try topanswers.xyz
Tom V - try topanswers.xyz
14:59
@McNets It's something about the cucina and the playa
McNets
McNets
@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.
Tom V - try topanswers.xyz
Tom V - try topanswers.xyz
I can see why they wanted to put him on shows
I can think of less funny people on TV
McNets
McNets
@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.
el risitas y su cuñao.
►
He was known as the-brother-in-law
Mast
Mast
15:34
@McNets His clips got famous all over the world with incorrect subtitles.
 
2 hours later…
ypercubeᵀᴹ
ypercubeᵀᴹ
17:43
@TomV-trytopanswers.xyz this deserves 11 stars! At least.
 
1 hour later…
DRP
DRP
19:07
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?
Mast
Mast
19:28
@DRP If the gender is in the same table, is there even a relationship?
DRP
DRP
20:12
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...
mustaccio
mustaccio
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…
Peter Vandivier
Peter Vandivier
21:33
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)
Max Vernon
Max Vernon
22:34
@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.
Cade Roux
Cade Roux
23:09
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 (1858 days later) »