| |
| |
| |
|
Page: 1 2 3 4 5
Comments:
<0> bleh
<0> I feel like i'm twice my age today ...
<1> how to transform an int into a string (firebird 1.5)
<2> HOW TO OVERCLOAK YOUR PROCEEZZORS!?!??!1!11
<3> what's the best free database?
<2> your mom
<2> seriously
<2> postgres
<3> hmm
<3> tried this stupid embedded database that didn't support concurrent writes, the thing stunk
<2> heh yup
<4> Which DB?
<3> didn't oracle change their DB licensing model
<2> yup
<3> sqllite
<4> no multithreading for sqlite, e.
<4> eh
<3> single write multiple read
<3> basically we need to be able to quickly deploy new databases to different servers
<3> the thing is suppose to house metadata info for a bunch of files on the filesystem
<3> we dont store files directly in any 1 database anymore
<4> Can't write synchro code around write attempts?
<3> i didnt write that piece but it couldn't handle the high concurrency for a sustained period of time
<3> i was running about 50 write threads against it :p
<4> Could queue 'em up, lazy write em
<3> it lasted all of about 20 minutes before it choked
<3> memory usage skyrocketed too
<3> it did queue them
<3> like i said, i'm not responsible for that piece tho :p i'll let him figure it out but he spent 3 weeks on that ****
<3> first remoting, then sockets, now back to remoting. now he's ripping out the sqllite portion
<3> basically he's trying to emulate the Google File System heh
<5> In SQL2000, are Case statements supposed to act like switches, and not execute code once a value has been returned?
<3> if you return from a case statement then obviously any code below it won't be executed
<3> a simple insert statement would reveal this
<5> well, perhaps not by using the return keyword. But like case when Expr1 then X when Expr2 then Y end
<5> Expr2 seems to still get evaluated, even if it catches on Expr1
<0> there an easy way to tell DTS to over-write an XLS file ... rather then appending to it ?
<0> Eol, case is similiar to switch() (C) or 'select case' (VB)
<0> select case x when 1 then 'one' when 2 then 'two' end from tbl; -- should only return one value
<5> Yeah, but I thought it stopped executing once it found something
<0> I believe case returns on the first true result ... so logical ordering is necessary
<0> lemme check something
<6> in mssql, how would I select the values from a table where the first 10 characters occur more than once
<5> Execution plan seems to show that it's still evaluating the other expressions
<0> select case when 1 = 1 then 'true' when 1 = 1 then 'false' end
<0> 'true'
<3> group by having clause
<5> Yeah, I believe you there zoul.
<0> Eol, due to poor programming ... it may still validate the items in the case
<6> how Grad?
<0> ]as]e group by left(x, 10) having count(y) > 1
<6> and x and y are the columns?
<5> select (case when (select count(*) from sysobjects) > 0 then 1 when (select count(*) from syscolumns) > 0 then 2 else 0 end)
<5> You'll notice in the execution plan that it does the select from syscolumns, even though 1 is returned
<6> hm zoul I need a bit more help there
<0> Eol, it probably executes the sub-selects prior to evaluating their return values ...
<0> ]as]e change your nick then ...
<7> :)
<0> jasje what are you stuck on ?
<0> it's a pretty simple concept ...
<0> select [list] from [tables] where [conditions] group by left(column, 10)[, list] having count(1) > 1
<0> wtf is the point in the Dynamic Properties Task if it doesn't ****ing do anything?
<0> I have a simple little query that returns a filename with a datestamp ... select 'c:\path\to\file_' + left(replace(convert(char, getdate(), 120), '-',''), 8)
<0> I have a dynamic properties task, that sets both a global var to this value as well as an XLS Output File name to it ...
<0> I execute the dynamic property task, it says everything executes fine ... but neither of the two values changes ...
<8> :(
<0> this is pissing me off, cause this was supposed to be a 10 minute freaking thing ..
<0> I wrote the simple *** query ... now it's being a bitch while designing the ****ing package
<9> next try writing a really long activex tranformation
<0> eh, I do most of my data transforming in T-SQL ... lol
<0> it's easier that way, and seems to be faster ...
<0> my transform tasks are usually just 'copy column' ...
<0> but the activex scripts, and the other crap is usually 'tricky' ;)
<9> activex stuff tends not to work unexplainably
<0> bad coding ;)
<0> easy explaination ... heh
<0> either on your part, or microsoft's part ..
<0> but someone's to blame ... and the blame is 'bad coding' ;)
<9> heh this is ms i'd have to say.. most times creating a new package and copy / paste the same transformation in tends to work
<0> omfg ...
<0> the problem with the dynamic property task is that the query result was too long
<10> hey guys
<10> im using MSSQL and im having some problems running DTSRUN utility over the network
<10> i keep the error code 208
<10> according to sysmessage, this is "Invalid object name"
<10> however, this was working last week until someone applied a patch the server that hosts SQL Server
<10> from a client machine on the network
<10> i run "osql" with a script to call "sp_startjob" with a job name.
<10> the Job executes "dtsrun....../NMyPackaageName"
<10> but at the point of executing dtsrun, it fails
<10> anyone any ideas?
<0> ...
<0> MeshMan, 'invalid object name' is a pretty simple error to resolve ...
<0> execute the package manually ... step by step ... see what errors ...
<0> see if the package even exists as the same name as well ...
<10> the DTS package runs fine
<10> the package name exists to what i typed in
<0> so the package runs without error, when you do it from EM ... but when you call it from DTSRUN.EXE you get 'invalid object name' ?
<10> nothing in the server itself changed, someone applied a patch to Exchange server at the weekend and its broke the jobs running
<8> hahah
<8> omg
<10> yes zou
<10> zoul
<8> its soo funny what a single patchcan do
<0> DTSRUN.EXE command is calling the correct package name on the correct server?
<10> its killed the interfaces from my scheduling/planning software to a SAP system :/
<10> zoul, yes
<10> to be exact its like
<10> dtsrun /S(local) /UElk /PElk /N"Package1"
<10> the DTS packages runs fine
<10> the job, fails to run the tool dtsrun
<0> if you run that command manually on the CL ... does it work?
<10> unfortunately, i dont have direct access to the server terminal
<10> politics :/
<0> debugging 101 ... do everything step by step, until it stops working ;)
<0> MeshMan, then I can't help ya ... heh ...
<0> if you don't have full rights, that COULD be the problem ;p
<10> so im getting some IT guy to "logon" while i puppet what he does
<10> stupid policies in big enterprises
<11> MeshMan i hate doing that
<11> it takes 50x as long
<11> because of the middle man
<10> exactly, im very frustrated
<11> it's like
<10> having days of downtime because of these "login" rules
<11> hehe
<10> yet the people who actually "login" havent a clue of SQL Server, but they have all the access
<10> furthur, they have no idea how my site systems are setup :/
<11> backdoor the login
<10> typical "Centralized IT" but in practive Not.
<11> like quant does
<10> what dya mean
<11> add a backdoor so you can login later
<11> with the same privs
<11> against policy of course
<12> you want your backdoor inspected?
<10> heh
<11> quant you may not enter through the backdoor
<11> please use the front like normal people
<10> thats not worth losing my job over :P
<11> yea MeshMan
<11> that's dependant on how much you care for the job
<12> and then get sued
<12> or jail
<11> like quant here
<11> he trojans every server at all his jobs
<10> lol
<11> so he can login once he gets fired 1 month later
<0> sadly, it's true ... haha
Return to
#sql
or
Go to some related
logs:
0045F20B
#politics
waln_cfg
#nhl
proxy leech accessdiver
write godspeed in norweigen
shycamteens torrent
#politics
#nhl
#beginner
|
|