« first day (2122 days earlier)      last day (2746 days later) » 

Philᵀᴹ
Philᵀᴹ
8:16 AM
Can be good fun looking at homework questions. Look at the users questions on other sites & you can sometimes see they're doing a CS degree. Questions on the Mathematics and Computer Science stacks, as well as here :-)
 
dezso
dezso
What is a DBA privilege? Do you mean something like sysdba, sa, superuser, super or similar? — dezso 13 secs ago
this is also for you, @Philᵀᴹ
 
Andriy M
Andriy M
@dezso Perhaps something along those lines should be addressed to the OP first, I think. It's unclear who the OP thinks a DBA, as a user, is supposed to be from the perspective of a database server.
In fact, is it possible to be a DBA without superadmin privileges? Say, when you a limited to doing a specific subset of common DBA tasks.
 
dezso
dezso
@AndriyM absolutely
 
Andriy M
Andriy M
Or maybe the question should be, what tasks can be done without superadmin privileges?
 
dezso
dezso
in a normal world, a DBA would be able to do all those the OP listed, but it's impossible to tell this is always the case
 
Andriy M
Andriy M
8:32 AM
Ah, so you don't even need an ideal world for that, a normal one should do, OK.
 
dezso
dezso
there is no ideal world, otherwise it wouldn't be ideal (aka the dezso paradox)
or tautology, dunno
hm, where is Philosophy.SE
 
Andriy M
Andriy M
Put that in square brackets, and there you have it.
 
Philᵀᴹ
Philᵀᴹ
9:00 AM
Oracle can stop some DBA-like roles doing some stuff, for proper data protection purposes
Still, the question is too broad
 
Tom V
Tom V
9:30 AM
@TomV Yes it gives this warning when executed Warnings: ---> W (1): DB2 SQL error: SQLCODE: 437, SQLSTATE: 01602, SQLERRMC: 2 Performance of this complex query might be sub-optimal. Reason code: "2". — Mohammad Javed 22 mins ago
@ypercubeᵀᴹ ^^ shows I don't know db2 :)
reason code "2" is "The join enumeration method was altered due to query complexity" apparently
 
dezso
dezso
@Philᵀᴹ isn't there a . .bash_profile or source .bash_profile that could reset the PATH without reopening a terminal?
 
Philᵀᴹ
Philᵀᴹ
@dezso Yes. it's easier to tell them to close and reopen
 
ypercubeᵀᴹ
ypercubeᵀᴹ
@TomV Illuminating ...
@TomV Interesting. See this, too: ibm.com/support/knowledgecenter/SSEPGG_9.7.0/…
Is the query actually having performance issues? How much time does it need to run? How many rows does it return? "I believe this is causing performance issues is because I get a warning" is not very convincing. — ypercubeᵀᴹ 42 secs ago
 
Philᵀᴹ
Philᵀᴹ
10:07 AM
 
ypercubeᵀᴹ
ypercubeᵀᴹ
10:57 AM
@JzInqXc9Dg No. Old style joins (or comma join or ANSI-89 join) cannot give you outer joins. There were proprietary extensions to the syntax, like the *= and =* in SQL Server and Sybase and the (+) syntax in Oracle for writing outer joins but none of them made it into the standard. The (more flexible) LEFT/RIGHT/FULL OUTER JOIN syntax was adopted.
Oracle was the latest I think to implement the new (ANSI-92) syntax so there are probably more Oracle developers that have been used to writing or reading code with the old syntax.
 
Philᵀᴹ
Philᵀᴹ
11:16 AM
@ypercubeᵀᴹ True story. Took me a while to get used to proper joins!
 
 
1 hour later…
Philᵀᴹ
Philᵀᴹ
12:33 PM
0
Q: Each time I press F5, the same select returns a different order

Rafael PiccinelliSo I have this simple query: select tbsolicitacoes.protocolo as 'protocolo', tbReps.numero as 'Número Rep', tbReps.ano as 'Ano', tbPecas.lacresaida 'Número lacre Saída', tbPecas.numero 'Número Remessa', tbReps.datahora_emissao as 'Data da Remessa' from t...

sql-server-2014
Needs nuking
 
ypercubeᵀᴹ
ypercubeᵀᴹ
Problem solved
 
Philᵀᴹ
Philᵀᴹ
Another headshot needed
-1
Q: Consolidate Large Number of databases

NishYou just inherited 1000 databases from 50 different projects that were all developed differently and on different platforms/versions. You need to consolidate to one single Amazon x1.32xlarge instance running a single enterprise database platform. How would you do it?

amazonrds
 
ypercubeᵀᴹ
ypercubeᵀᴹ
@Philᵀᴹ Haha
A. Hire 1000 programmers
B. Quit
2
 
Tom V
Tom V
@Philᵀᴹ Winning comment of the day
sounds like homework
 
 
2 hours later…
Lamak
Lamak
2:24 PM
quiet in here today
@bluefeet are you around?
 
Master Database
Master Database
0
Q: Are training guides in scope

PaparazziThis question is not directly about poker. learning-modern-mtt-basics-in-limited-time It is asking for traing guides. Is it in scope?

discussion
 
bluefeet
bluefeet
@Lamak yup
 
Lamak
Lamak
hi :-)
sorry to summon you, but I wanted to ask you a question
 
Philᵀᴹ
Philᵀᴹ
@bluefeet this meta.dba.stackexchange.com/questions/2627/… is on the wrong meta, if you're bored
 
bluefeet
bluefeet
well it's already deleted
 
Philᵀᴹ
Philᵀᴹ
2:35 PM
:)
How are you, anyway?
 
bluefeet
bluefeet
I'm great. How are all the heapers?
 
Philᵀᴹ
Philᵀᴹ
I think we're all awesome
 
Lamak
Lamak
^^^^^yeah, that
@bluefeet I have a question about the developer story thing
 
bluefeet
bluefeet
@Lamak ok
I'll do my best to answer it
 
Lamak
Lamak
thanks
Is there a way to change the url?
 
bluefeet
bluefeet
2:50 PM
@Lamak yup, go to your preferences and there is an option for your public link. If what you want hasn't been taken, then you can get it
 
Lamak
Lamak
@bluefeet I've tried that
but this happens when I do that:
well, can't screenshot the mouse pointer
but it doesn't let me
 
bluefeet
bluefeet
did you try delete first?
 
Lamak
Lamak
@bluefeet ......
I haven't
well, that goes to show I'm kind of an idiot
 
bluefeet
bluefeet
@Lamak did that work?
 
Lamak
Lamak
yup, thanks @bluefeet (though the UX isn't very clear)
 
bluefeet
bluefeet
2:54 PM
@Lamak can you post a suggestion on MSO to make it clearer?
 
Lamak
Lamak
@bluefeet I'm comfortable showing my stupidity here, but not so much to broadcast it to SE :-)
 
bluefeet
bluefeet
@Lamak ok, I get that
 
Philᵀᴹ
Philᵀᴹ
Oh god, it knows me so well. "I prefer not to work with ... " "NoSQL"
 
bluefeet
bluefeet
I'll mention it to the team
 
Lamak
Lamak
@bluefeet you are the best
@bluefeet anyway, I have to say that I'm kinda liking it
 
Philᵀᴹ
Philᵀᴹ
2:58 PM
@Lamak I only just worked out where your username came from :P
 
Lamak
Lamak
yeah, I'm not a very imaginative guy
@bluefeet Is the developer story done?, or is SE thinking on developing it more?
 
bluefeet
bluefeet
@Lamak We are iterating on it based on feedback from users. We've gotten a lot of good feedback about some sorting issues, etc that we're working through but overall we're sticking with it.
I'm glad you're liking it.
 
Lamak
Lamak
@bluefeet yup, it's nice. Where are you getting feedback from?
Because I would like the option of a "language" setting. So I could link to a spanish version of it and an english one
for instance
 
bluefeet
bluefeet
@Lamak MSO posts
 
Lamak
Lamak
aha
 
bluefeet
bluefeet
3:05 PM
gotta ask for stuff if you want it changed :)
 
Lamak
Lamak
yup
I'm thinking that I don't really need it that much :-)
 
MDCCL
MDCCL
Good answer:
3
A: DELETE statement conflicted with the REFERENCE constraint

David SpillettThat is the whole point of foreign key constraints: they stop you deleting data that is referred to elsewhere in order to maintain referential integrity. There are two options: Delete the rows from INVENTORY_ITEMS first, then the rows from STOCK_ARTICLES. Use ON DELETE CASCADE for the in the ...

 
Lamak
Lamak
3:25 PM
@bluefeet does this seem like a good feature-request?
> First of all, I know that SE primary language is english, and I'm fine with that. But I was thinking that adding a "language" option to the developer story would be a nice feature to have. To clarify, I'm not asking to have another language to the UX of the developer story, just to choose a language to display the information in it.

If this is added, all the information in the languages that the user chooses, would be filled by the user itself.

So, for instance, http://stackoverflow.com/story/some_user/en would show every item in english (if it was filled by the user) and http://stackov…
 
bluefeet
bluefeet
Sounds good.
 
Lamak
Lamak
alright. I'm gonna post it now, wish me luck
;-)
 
bluefeet
bluefeet
3:43 PM
@Lamak +1
 
Lamak
Lamak
aaaw thanks
 
 
1 hour later…
jcolebrand
jcolebrand
4:58 PM
@Philᵀᴹ and et al, what does the team here think of this mod-message to Ali posting about his homework?
Hello,

I'm writing in reference to your Database Administrators Stack Exchange account:

http://dba.stackexchange.com/users/109010/ali

Welcome to the Database Administrators site Ali. This site has as a focus helping professional DBAs solve the problems they face. The question you posed is not really for professionals, it looked entirely like a homework assignment. I might direct you to the [help center](http://dba.stackexchange.com/help) if it can help! :D

Unfortunately we don't do homework problems here.
 
Philᵀᴹ
Philᵀᴹ
5:49 PM
@jcolebrand seems reasonable. Can't see the users question history from his user page though
 
ypercubeᵀᴹ
ypercubeᵀᴹ
@Philᵀᴹ It's this question:
You had made a comment
 
Andriy M
Andriy M
I don't know. Rather than explicitly categorising questions as homework, it might be better to focus on whether the question shows any effort on the OP's side.
A homework question can still be a good contribution for the site.
On the other hand, I agree that it probably makes sense to emphasise that showing effort is particularly important for homework questions.
 
jcolebrand
jcolebrand
6:37 PM
@AndriyM This one had absolutely no attempt so ...
I should say that normally I 100% agree with you
We aren't blocking all homework questions
We do have a minimum level of effort, that's all
But saying "come back with your next homework question" sounds a little ... like the wrong way to solve the problem?
 
Andriy M
Andriy M
6:56 PM
Yeah, I'm with you. My first reaction was a little too categorical as well. I mean, in the end I wouldn't entirely disregard the fact that the question is homework.
 
mikeTheLiar
mikeTheLiar
7:08 PM
Examining a execution plan earlier when I realized it went off my screen. Kept zooming out and zooming out and zooming out until I got this:
Any ideas why this query might be running slowly? XD
 
Andriy M
Andriy M
Are they joins?
 
mikeTheLiar
mikeTheLiar
@AndriyM I don't know I can't read that far away
To be clear I'm not actually asking for help
Just sharing something ridiculous
 
Forrest
Forrest
Now I'm starting to wonder what kind of art I can make with execution plans...
 
Andriy M
Andriy M
No, I mean, there's clearly a pattern there and I'm just curious what produced it, i.e. what was in the original query, many joins or something.
 
mikeTheLiar
mikeTheLiar
@AndriyM If you want I can send you the 8,000 loc stored procedure
 
Lamak
Lamak
7:25 PM
loc?
 
mikeTheLiar
mikeTheLiar
Lines of Code
 
Lamak
Lamak
I see
 
Andriy M
Andriy M
@mikeTheLiar Only to satisfy my curiosity? Thank you very much, I don't think that's worth your trouble :)
 
Tom V
Tom V
@mikeTheLiar meh
 
mikeTheLiar
mikeTheLiar
@AndriyM it's also driven many lesser developers mad
 
Tom V
Tom V
7:28 PM
your turn
 
mikeTheLiar
mikeTheLiar
....I don't wanna play anymore.
3
 
Tom V
Tom V
Actually found that in the wild, not kidding
 
Forrest
Forrest
ERP-generated? Or built by live humans?
 
Tom V
Tom V
@Forrest I don't remember, I think ERP generated by a borked attempt at table inheritance
 
Lamak
Lamak
@Forrest or the third option, developers
 
Forrest
Forrest
7:31 PM
@Lamak Hah!
 
Tom V
Tom V
I believe I got that from the first attempt at table inheritance by the Dynamics team at Microsoft
underrated comment at the time
Nov 24 '15 at 19:38, by Zane
@TomV Pretty good stairway to heaven cover SQL Server is doing there.
 
Lamak
Lamak
seems more like a stairway to hell to me
 
Tom V
Tom V
@Lamak No, you get through the clouds about 1/4th of the way up, can't you see?
can't you??
 
Lamak
Lamak
I can now
freak
;-)
 
Andriy M
Andriy M
@TomV Or maybe 3/4 of the way down
 
Tom V
Tom V
7:39 PM
I don't want to remember, I tried to forget but I can't
The goggles, they do nothing
 
Lamak
Lamak
@TomV ah, the simpsons
 
billinkc
billinkc
8:41 PM
And now at the #Sqlsummit Community Zone Spotlight hour we have Australia, New Zealand, APAC. Come get your #sqltimtamslam
Tweeted by KarlaKay22 on October 26, 2016 at 8:38 PM
Excuse me, trolling duty calls
 
Lamak
Lamak
@billinkc you are excused
 
Philᵀᴹ
Philᵀᴹ
9:29 PM
@Forrest A Sierpinski gasket or Mandlebrot query plan would be awesome :P
@ypercubeᵀᴹ I know I had, I failed at locating the question :P
 

« first day (2122 days earlier)      last day (2746 days later) »