The Heap™ – Consultancy ©®

« first day (2033 days earlier) ← previous day next day → last day (2839 days later) »

Phil

7:28 AM

Mornin'

dezso

8:16 AM

to you too

@Marian except that the team changed their mind(s) to use another backup (from one day later), so some parts of the process were tested not only once but twice

Jack Douglas

8:31 AM

@Phil If you clone an entire machine with Oracle 9i, change the IP and bring it up on the same network, clients will all continue connecting to the original machine won't they?

Phil

8:51 AM

@Jack yeah

Jack Douglas

@Phil thanks – it doesnt depend how the clients are doing oracle name resolution then?

Phil

9:11 AM

Yup. If it's just DNS based, you're fine

ypercubeᵀᴹ

9:51 AM

Q: Hash Match inner join in simple query with in statement

I am running the execution plan for the following query: select m_uid from EmpTaxAudit where clientid = 91682 and empuid = 42100176452603 and newvalue in('Deleted','DB-Deleted','Added') Here is the execution plan: I have a non clustered index on EmpTaxAudit Table on ClientId and NewValue...

Not a very bad question

Jack Douglas

10:02 AM

@Phil think we found the problem — there is a samba server on that box and something WINS related is affecting name resolution on some clients!

Phil

10:18 AM

@JackDouglas VtC: This question belongs on another site

Jack Douglas

10:34 AM

Andriy M

11:31 AM

I'll add an answer a bit later on this, but I've created a chatroom for users to discuss the SQL tag/topics, etc here is a link. — bluefeet ♦ 2 days ago

That's not a link to a chatroom there, @bluefeet

Looks more like a link for recursion connoisseurs to me.

bluefeet

I don't know what you're referring to. :P

thanks

Tom V

No, m doing it online. I went to w3 and pl/sql environment and m doing the whole thing from there , i wanted to do it for free due to money restrictions but it seems like I will have to take a proper course for it? However all I want to know is, if I do it properly from and institute and get a certification, will then I be able to earn some money using this sitting at home? Also is there some other way of doing this course and getting the certification without spending money? Hope u an help me out with just this query. — user273965 27 mins ago

2 hours later…

dezso

2:02 PM

@TomV dba.stackexchange.com/questions/145319/… you might want to delete this, as the question is about PostgreSQL

Did you realize this question was about PostgreSQL? Also that there is already an index on age? — dezso 41 secs ago

and

How many different genders do you expect? Will it add any selectivity to the index you propose? — dezso 9 secs ago

(same question, different answers)

and

@MichałNiklas it does not. — dezso 18 secs ago

ypercubeᵀᴹ

2:29 PM

@dezso I expect 4 ;)

dezso

@ypercubeᵀᴹ very good :) still, this does not really change my point, I believe :D

ypercubeᵀᴹ

@dezso I've commented, too.

I agree the index would not be useful for the query.

2 hours later…

mmarie

4:16 PM

crickets

Phil

5:15 PM

On Uber’s Choice of Databases: use-the-index-luke.com/blog/2016-07-29/…

Phil

5:26 PM

"Unfortunately, I understand and even agree with this argument. Instead of “most engineers are not database experts” I’d even say that most developers have very little understanding of databases because every developer that touches SQL needs know about transactions—not just database experts."

2 hours later…

bluefeet

7:52 PM

If you want to help

Q: Let's organize the SQL documentation

Documentation has been in public beta for about a week, and some users have pointed out a few issues with the SQL docs, so before things get too unwieldy let's address some of the issues. I mentioned in my comment earlier this week and have been thinking about ways to fix them before they get to...