Did someone just ask me to link the room in the Teacher's Lounge for no reason? Because that's how you get someone to link a room in the Teacher's Lounge for no reason
Much like the vein of the question that was posted here previously around "Should developers be able to query production databases?" I wanted to get your thoughts on another particularly annoying topic!
Many companies prevent developers from install SQL Server Express and the like on development...
Cost is less of an issue than additional time spent waiting for procurement
My coworker, who has over a decade of experience on his resume developing for this stack, insists we need full versions of SQL Server installed on our workstations in order to start on a project that is already months behind schedule. But he also said to me recently that he has never used commit and doesn't think it's necessary
I didn't ask him if he knows what a transaction is because I would rather live in happy ignorance
@ypercubeᵀᴹ Interesting how that slipped by me. guess because I have Dreamspark from my University, and I have three SQL Server licenses thanks to that, I just don't bother keeping tabs on things.
I'm using SQL Server 2014. There are some users who can query the tables. The problem is, that most of the time these queries use a lot of memory. I want to know if there is any way to limit resources per user?
Good question IMHO but the answer is just asking for the OP to come back in a few weeks, with the question "I've got a performance problem....what is the issue?" Is it legitimate to just answer the question without supplying some performance analysis and tuning recommendations?
@hot2use There was a comment on a deleted answer that the OP should have included in the question. I have edited that in now. It seems he had a problem with adhoc user queries consuming too much workspace memory, so RG is likely the best option. On the broader point: yes answers that answer the question are valid. It is often possible to contribute a better answer or suggest/make improvements to an existing one.
In SSMS object Explorer, click Management
Right-click Database Mail
Click Configure Database Mail
4.Select Set up Database Mail by performing the following tasks
5.Enter a profile name and click Add
6.Enter the settings for your email account. I could not set the account for my company...
SELECT translate('["foo", "bar"]'::jsonb::text, '[]','{}')::INT[]; ERROR: invalid input syntax for integer: "foo" It's not so bomb-proof... — dezso1 min ago
I sometimes get it it too and look at the submitted changes in a separate window to decide whether to add them to mine and submit or to cancel mine.
Because sometimes it's easier to add changes the other party overlooked as a separate revision started anew, and sometimes it's the other way round and it's easier to include those I overlooked to my current edit.
I'm often hesitant to answer SQL questions because at some point @ypercubeᵀᴹ will show up and say "yes but you didn't handle X edge case, and this is more efficient by the way"
@Sami Yes, I remember you requested earlier if he'd agree if you asked him a question, and he did agree. But that's still what I'm trying to understand: the fact that you wanted to ask your question specifically of Paul.
@Sami I mean, I know Paul's got first-class knowledge of SQL Server internals. He's written blog articles about that, he's given presentations on that topic – everyone knows that. I've never heard or seen him demonstrate his profound knowledge of configuring database mail, though.
And that's why I'm asking, because by choosing to address just Paul, you might be limiting your opportunities to get better help. If you posted your question on the site, you'd get more eyes on it, and potentially more experienced eyes too.
2
@Sami Of course, posting a question on the site may mean more work, because, well, the crowd here may be somewhat demanding with regard to how clear your question is or how well you did your homework. But by putting more effort into it you may find the result to be more rewarding as well.
@ypercubeᵀᴹ @PaulWhite is the resident Gmail relay expert
@Sami , please understand that this chat box is a place where you can ask a one-off question, and we are willing to help, but we are not a personal support desk. If I remember correctly we didn't see an actual complete error message, but what we did see was an error message originating from the mail server
as long as the mail server is giving you errors, the problem doesn't appear to be on the database end, so you really need to talk to somebody who understands your e-mail setup
@PaulWhite I'm not sure my assumptions are correct, on the one hand the exists seems to be the influencing factor, but on the other hand the query inside the exists seems to influence it as well.
I suspect a combinatino of the exists clause and the not exists inside the query, but what do I know about that
However, the NOT EXISTS could be interpreted by the planner as "we don't expect any rows to be returned"
@Sami I mean, if it's a quick question, like you asked first when showing the error it's accepetable, but a multiple-hour troubleshooting session isn't
"une erreur de serveur de messagerie" should be an indication that you should look into what error your mail server is sending and investigate that, we can't do that for you
and I doubt it would be a great question for main either actually
What is the actual mail server error, it'll be either authentication failed or relay not permitted, which we can't fix for you, or you can't fix on the database end without knowing what is allowed by the mailserver
@Sami That's not a problem, I suck at French too, but there are many forums in many languages that would return a result if you searched for the actual error message
@Lamak yeah ... but it should be fun. a few days' downtime in cinque terre and amalfi coast area should be nice to make up for the whirlwind time in rome and florence
@swasheck we had a more chaotic trip though. It was something like Barcelona->Paris->Brussels->Amsterdam->I don't remember the name in Slovakia->Berlin->London->San Marino->Rome
@Lamak oh my ... yeah ... we're doing denver -> nyc .... -> nyc -> denver. once we're in italy we're averaging 3 days per city. just enough time to get used to it and then then load up and take a train
You are likely looking at two tables: One is a lookup/reference table that holds the list of allowable values. You then store the information into a different table and define a relationship (foreign key) from Users table to Gender
@UDKOX Whatever the language, your app should be able to read from tables. Make it - when it starts - read from that "gender" table. Then it will know that 1 is Man and 2 is Woman.
I'm using SQL Server 2014. There are some users who can query the tables. The problem is, that most of the time these queries use a lot of memory. I want to know if there is any way to limit resources per user?
In SSMS object Explorer, click Management
Right-click Database Mail
Click Configure Database Mail
4.Select Set up Database Mail by performing the following tasks
5.Enter a profile name and click Add
6.Enter the settings for your email account. I could not set the account for my company...
