| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9
Comments:
<0> yep
<1> do you have
<1> instances?
<0> instanced zones?
<1> yeh
<0> yeah its the only way to handle the load in some zones
<1> instaced for a group only
<0> yep
<0> pretty much all the magic and ideas from both came from ad&d... and the gameplay looks almost identical to eq1 and 2
<0> its the mac of mmorpg
<0> no different in anything but looks and advertising
<0> ok bed time
<0> night
<1> nite
<2> what can be an exaplme of a SQL query involving 40+ tables?
<3> huh?
<2> example
<3> not sure what you're even asking
<2> I wanna see a legit sql query with more than 40 tables in it...
<3> a heavily normalized database with a query that pulls excessive detail could be that large
<3> student50, it certainly happens, but i'd say rarely
<3> also, partitioning data could yield something like that
<2> can u point me to an example
<3> of course not
<3> can i ask why you care?
<3> it depends on the business system and application whether there is a call for a 40 table query
<2> I saw it as a requirement on an ad for a vb programmer
<3> heh
<2> the requirement being that you can understand something that complicated
<3> say yes and move on
<2> they'll be testing me
<3> whats the largest number of tables you've ever referenced in a single query?
<3> cause i'd be surprised if the average intelligent person ever has more than ten max for a typical scenario
<2> here's their full job description:
<3> and the number of tables has little to do with being able to understand it
<2> Qualifications :
<2> *Expert VB6 Application developer *Expert database developer (stored procedures) *Expert in ADO *Experience with OCX *Experience in Extreme Programming or Agile programming methodology *Experience writing and troubleshooting complex stored procedures and DLLs (complex SQL queries involving 40+ tables)
<3> what type of company
<2> doesn't say
<3> extreme programming/agile programming can **** my ****
<3> i'd toss it just based on that, but whatever
<2> lol
<3> again, i'd just say yes
<2> the pay rate is really high
<3> no one throws a 40 table 'complex' proc at you and expects you to understand or modify it in 5 mins
<2> so I dont think they're looking for just anybody
<3> whats the salary
<2> 50-70/hr
<3> well, just like you lied about half the **** on your resume, they exaggerate and lie in their requirements.
<3> i'd just say of course i can do that provided i have the context and sufficient time to debug properly
<2> but thats a lot of money for a stupid programming job
<3> do you have proc experience
<3> not stupid
<2> yeah some
<3> ocx, dlls
<3> sounds like they're looking for an experienced db developer with advanced skills
<4> sure thing
<3> i vote for 'say yes and mean it'
<3> and so what if they test you on it
<3> if you fail, you'll be the wiser since you'll know what you need to know
<4> 70-80/hr is not easy stuff ;)
<3> failing is good.
<3> if you're a prostitute it is.
<2> I've already said yes they'll be testing me tomorrow
<3> or a clown for kid's birthday parties.
<4> what has it do with sql?
<2> stored procedures...
<3> dunno, but i've worked with some real clowns on db's
<4> query your ***? LOL
<2> 70/hr full time!
<3> why don't they quote salary
<3> why is it hourly
<2> 70*40*52
<2> how much is that
<3> heh, thats what YOU think
<3> full time == 65 hours per week
<2> donno why
<3> 70 * 8 * 22 * 12
<2> 5days * 8/hr a day=40 hr
<3> 22 in a month approx
<3> 22 days
<2> there are 52 weeks in a year
<3> sometimes
<2> where did you get 65hr/week?
<3> heh, my current job?
<2> lol
<3> btw, if you use my calculation you'll earn more money
<2> anyways we're talking about about 150k
<3> like an extra 2 grand a year
<3> yes, thats a chunk of change
<2> so they're definately not looking for someone like me lol
<3> my guess is if you're questioning whether you're qualified for a 150k/year job then you're not
<2> exactly
<2> not a lot of ppl are
<2> a regular programmer is paid about 30k to 55k
<2> I've never heard anybody getting more than 55k
<2> not unless you're in a managerial position of some sort
<4> lol why are you questioning him he doesn't know that compay :P
<4> neither do we :P
<2> what diff does it make what company it is?
<4> it does
<3> it would give some context
<3> if it was wells fargo, i'd say thats a bit different than xxxsqlsluts.com
<2> but as long as as the pay rate is the same I still dont see any diff...
<3> ok
<5> did someone say XXX SQL SLUTS
<5> ...how would that work anyway
<3> tight young dba's
<5> sounds like the new intern at work
<5> minus the dba part
<3> whats he look like
<5> she
<5> i don't look at other guys and think "tight & young"
<5> haha
<3> 'man, you are one hot sausage jockey'
<3> xxxsqlsluts.com is available
<3> 'Come to xxxsqlsluts.com. Find out what we really mean when we say mySQL ****s!'
<5> some chick with a mySQL shirt haha
<3> 'mySQL doesn't ****. *I* ****.'
<6> hi
<6> i have a problem with a query
<6> how to i slect records within with date property for a particular month i.e. all records with a month property of january?
<7> hi
<7> anyone know how to rewrite a "not in" subquery to use a join instead?
<8> if you can paste the not in version to a paste service, yes
<7> i've never heard of a paste service before, but i followed the link in the title and pasted it. Thanks
<9> moo: just a hint, you should paste the url here so other people might go and look at it also
<7> http://sql-servers.com/nopaste/
<7> thanks for the tip :)
<9> you are an idiot
<9> but in short... it works like this: "select * from table1 where id not in (select id from table2)" becomes "select a.* from table1 a left join table b on a.id = b.id where b.id is null"
<7> haha i meant http://sql-servers.com/nopaste/?show=154
<7> ahhh
<7> thanks
<9> if you arent bright enough to paste the full url so other people will go look at it and when you paste it you paste the wrong one... i dont know if you should be doing complicated queries like "not in"
<7> it's not a matter of intelligence, it's a matter of being in an unfamiliar desktop environment and making a mistake
<9> well now u know
<7> yup thanks
<10> i know this is wrong... select Email,Answer,max(SubmitDate) from Comp group by Email
<10> hi, soryr
<10> sorry :S
<10> how do i get the answer ***ociated with the latest record?
<11> what database?
<10> sql server
<10> i know its probably simple i just dont know how to do it :S
<12> given an accounting app with 100-300 (boundless scaling would be great, but 300-ish is absolute minimum) accounts, creating a new database for every individual client would be crazy, right?
<13> eevar_: Yes.
<14> J2k^^^: something like: SELECT Comp.Answer, dt.* FROM (SELECT Email, MAX(SubmitDate) AS LastSubmitDate FROM Comp GROUP BY Email) AS dt INNER JON Comp ON dt.Email = Comp.Email AND dt.LastSubmitDate = Comp.SubmitDate
<15> Is there anyway to increase the size of a Varchar without having to drop the table and recreate it?
<15> anyone awake?
<13> I think you'll have to at least drop and recreate the column with an alter table.
Return to
#sql
or
Go to some related
logs:
#politics
#computers
#freebsd
#netbsd
#politics
#nhl
#politics
#computers
#netbsd
emulator swg precu
|
|