| |
| |
| |
|
Page: 1 2 3 4 5 6 7
Comments:
<0> **** out of luck
<1> isn't that 'sool' ?
<2> no
<2> :)
<1> stupid english speakers
<2> hah]
<3> actually, it's "**** outta luck"
<2> stupid racsists
<1> there ya go
<1> did you see that cingular patented the emoticon
<1> i'm going to patent *********ion. i could retire just based on the residuals from this channel.
<3> dfworking : actually, they patented 'one-click' emoticons
<1> like it matters. what a waste of the copyright process
<3> so you'd still get a load of money from this channel if you patented one-click wanks
<1> one-stroke
<3> dfworking : patent process - nothing to do with copyright
<1> argh, the INTELLECTUAL PROPERTY process
<3> well, now, that *really* opens up a can of worms...
<3> how sweet
<1> next thing i'll do is patent 'the act of correcting another's misuse of descriptive narrative to describe a concept that is clearly understood'
<1> then i could retire just from infringements by the ops in this channel
<3> that'd fail - too much prior art...
<1> nevertheless
<1> its my turn to tie up the process with useless dribble
<3> now we're back on the one-stroke wank again
<1> sheer genius
<3> juts out of interest, why are you doing joins between linked servers?
<3> s/juts/just
<3> that's gotta be right up there with multi-master replication as a not too good idea
<1> i have several instances of an application that has a 'core' data db, and a stats db (for each). i have another sqlserver that i'd like to ***ume the reporting burden for (ad hoc queries run for reports), and i'm not interested in replication or anything like that
<1> the current setup is bull****
<1> which is another app server querying the application db's live
<3> well, the ge erall idea of a reporting server is to take the load off the main server
<1> cause the people i work with are ****ing idiots that have no concept of doing things the right way
<1> yes
<3> if you're doing linked joins that won't be the case
<1> i know, which is why its not being done that way currently
<4> does anyone here know how to get the return value of a insert statement when called within a stored procedure
<3> MasterX : 'insert' doesn't return a value
<1> there is no return value
<3> dfworking : the thing to do is take a dump of the prd db overnight, and load it onto the reporting server
<1> yeah, but its ****ing huge
<1> collectively
<4> how do i get a number showing the number of rows inserted after a insert command
<3> so?
<3> MasterX : @@rowcount
<3> and what do you mean, collectively
<3> you palnning on one reporting server for all the app servers?
<1> i had thought if i wrote some scheduled jobs from the reporting server which essentially preaggregate the stats data into daily increments (reports are only accurate to full days), then i would be doing myself a favor
<1> ideally
<1> but i don't want to copy db's or replicate
<3> dfworking : that's the right idea, but the wrong place
<1> where is the right place then
<3> do the aggregation overnight on each prd server
<1> and push it to the reporting server?
<3> yah
<1> why wouldn't i do it nightly FROM the reporting server?
<1> rationale is that i don't have to affect my production apps for reporting purposes
<3> 'cos it's cheaper in network
<1> how about stored procs in the production apps that i call nightly from reporting
<1> again, trying to minimize the impact of somethign thats strictly related to the manner in which we implement a reporting solution
<1> tomorrow my boss may grow a brain and buy an enterprise solution that works
<3> that's better, but remember that if the proc is just doing an aggregate select of data to the reporting server, all the time it's running, the table is locked
<1> as opposed to?
<3> you're better off having the sproc create local aggregate tables
<3> then bcp them out
<1> thats what i was hoping to avoid
<3> zip the output file, then move that over the network
<3> network is slow
<1> it will change my application just to make the crappy reporting solution work better
<3> why?
<3> you can do all this inside DTS
<1> more aggregate tables, a nightly job
<3> no need for an app change at all
<1> so, create them on the fly, run it, push it, delete?
<3> why delete the tables?
<1> i don't have to
<4> is the Select statement the only statement that can be used in a stored procedure to print a message
<3> generally a bad thing - by all means truncate them at the start of the process
<3> MasterX : no
<4> whats a nother one
<1> and the dts is on the production server, is that so?
<3> MasterX : depends on the rdbms
<5> MasterX: in oracle dmbs_output.put_line
<4> ms sql 2000
<5> dbms_output that is
<1> so, the dts needs to know where the reporting server is. would have preferred it the other way around
<1> executing a dts package accepts params?
<1> i don't deal much with it
<3> MasterX : you need to refer to your documentation
<4> ok
<4> thanks for the help
<3> biab
<6> i got a small sql prob
<6> seems to look right but im getting a wierd error
<6> anybody alive
<5> yeah
<7> about half the world
<6> can i paste a sql statement
<5> and the geeks in the sleeping part of the world :)
<7> online, yes
<7> nopaste
<6> INSERT INTO module_courselocations ( merchant_id, location_street1, location_street2, location_suburb, location_state, location_country, location_postcode, date_created, date_updated ) VALUES ( '28', asd, asd, asd, asd, asd, asd, 2006-01-27, 2006-01-27 )
<6> its not big
<7> (unless it's short)
<6> heh
<1> it will be bigger if you add quotes
<6> oh damn
<6> hahahahahaha
<6> i should sleep
<1> agreed
<6> thankyou
<7> we spent the last month building ourselves a new office
<1> so qa actually uses a completely different method to connect to the db. it appears EM uses odbc if you try to execute a sql statement from within it, is that so?
<1> cool
<7> small office, but nicely done, if I may say so myself
<7> http://www.duotix.com/ftp/kantoor01.jpg
<1> very nice
<7> that's me in the picture btw
<1> you're a guy?!?!?
<7> and my brother made those painting myself
<7> you're not a guy???
<1> heh
<1> looks good dude
<7> cheers
<7> see the "x" in the desk?
<1> yes
<7> it's because doutix is our company name
<1> which means?
<7> duo = two, tix -> tex -> latin for web...
<1> gee, bet you don't have to explain THAT a lot
<7> not too many ask where it comes from :)
<1> ignorant losers
<7> oh and bought a new car too
<1> ****, i'm moving to where you are
<7> a company car to add stickers on, to get attention :)
<7> see: http://www.duotix.com/speedster/01.jpg
<1> you live in yugoslavia, no
<7> hehe, silly man like you would ever forget where I'm from
<1> nice, is that it?
<7> ;)
<7> yeah that's the one
<1> masda
<1> z
<7> opel
<1> oh
<1> cool
<7> http://www.duotix.com/speedster/02.jpg
<7> pretty speedy thing
Return to
#sql
or
Go to some related
logs:
pavilion 513w network drivers
#unixhelp
#stocks
#beginner
#gentoo
#mirc
Lamburghini Gallardo
bad pool header error on nero
#politics
#sex
|
|
