| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Comments:
<0> so i told him the easy way
<1> yes... I am mentally handicapped
<0> yep you are an mcse
<1> even though though I have setup solaris
<0> well technically mcp ;)
<0> setup ;) is just pointing and clicking
<2> Hate it when the colo techs decide to turn off the WRONG machine.
<1> i setup oracle on linux before :p
<0> wow oracle on linux setup is just pointing and clicking too
<1> no it isn't
<0> yes it is
<1> writing db scripts etc?
<0> you didnt write db scripts
<3> mvp
<0> since thats the stupid way to setup create a db
<1> i give up
<1> what are you trying to prove anyway
<0> nothing
<0> why does something need to be proven?
<3> because you attack people
<3> like you're proving something
<1> i don't know, I just ***umed you were trying to make a point
<3> and like everything the other person is saying is wrong
<0> nope
<3> and thats how everybody else takes it
<0> thats why everyone is wrong =)
<3> of course- and there you go again
<1> no kidding "i don't think drakh can comprehend"
<3> \doing the same god damn thing
<0> cant teach an old mcse new tricks
<3> neither can you teach a linux zealot to be sociable
<3> :p
<1> lol
<1> im not old :p
<1> and I love unix and linux
<3> thats about the onlything i like dealing with MS people
<3> versus *nix people
<3> 97% of the time you will find people that are 1000 times more sociable
<4> unix and linux?
<1> so I'm not exactly an old dog ;p
<4> wdf?
<3> then some *nix tard who has to get you into a pro-religion, anti-religion, anti-linux, pro-linux, anti-ms
<3> argument if they are capbple of managing a talk
<3> s/a/to/
<1> yea you started off helpful then you started insulting me just because I use a different distro then you
<1> :/
<0> and?
<1> you should hug me and apologize
<1> :>
<0> you will consider rhel and centos more strongly in the future
<0> so it worked
<1> lol
<0> same reason i bashed people in #oracle. they either realize it is too hard for them and quit toying with the idea that they will be a super cool rich dba
<0> or they will grow some balls, and learn more than they could have before in spite of me
<0> Quant is the former... he got banned and got all girly and upset
<0> shrike is the later, i banned him a few times. hes now an op there and very well versed in it
<0> People who cannot handle disagreement shouldnt be in the tech industry... unless they are mcse gates clones
<3> Jarett__ there is a difference between disagreements
<3> discussions
<3> conversations
<3> and people that attack :)
<0> not really
<3> or who are incapable of stating statements without adding some sort of bite to everything they state
<3> some people are capable of differentiating betweenthem and are capable of controlling them while others deny that they exist.
<3> they do exist. and there is a very big difference
<5> JarretT: Hey! be nice to the MCSE gates clones!
<5> ;)
<0> yes there are millions of them... i guess i should be :P
<0> like my 12 year old neighbor
<0> and a 9 year old indian girl
<1> Jarett__!
<0> ahahahah
<5> does my mcse nt4.0 count for gates clone?
<1> would it be equally lame to get something like linux+ or rhce
<1> as mcse?
<0> linux+ yes
<1> why that one in particular? too easy?
<6> how the hell is it possible that a 23mb text file, after running it through a script that removes newlines, turns into a 2mb ****ing file?
<3> lots of whitespace?
<5> I took the new SQL 2005 mcdba upgrade exam, it was a bit better than the old SQL exams tho.
<3> or data loss?
<6> Arrakis, haha, thats a ****LOAD of ****ing newlines ...
<6> even given it's a windows newline, which is 2 byte (\r\n) ...
<1> Jarett__
<1> are you an oracle dba
<5> zoul: visual inspection of the beginning of the file?
<6> Inge- ... what do you mena?
<0> im a systems engineer ;) thats a part of my job.
<5> zoul: sounds like the script might have removed non-blank lines .. a visual inspection could possibly give a quick and easy clue :)
<1> cool
<1> oracle is sweet
<6> Inge-, if i can't figure it out programmatically, then I'm not gonna figure it out ..
<6> they don't pay me enough to check byte for byte why there's such a large difference ;)
<3> lol
<3> opening then up in notepad oughgta be a good enough to see what happeend
<6> if the file were nothing but newlines, it'd contain 12259328 newlines (filesize in bytes / 2)
<3> perhaps it also removed whitespaces too ?
<3> and there were lotso f them?
<6> the file contains 121369 new lines ...
<3> i know alot of ms logging applications liike to insert
<3> thousands of whitespaces
<7> this is gonna ****, someone didnt notice a runaway spid on one of our sql7 servers, its been running away for about 2 weeks, filled up the tempdb and the disk, that was easy enough to fix, kill spid doesnt really kill the spid, it just marks it as dead
<6> which is about ~237k
<3> restart sqlk server?
<0> Rizar_d, time for the 3 finger microsoft fix
<3> rofl
<1> rehboot !
<6> bah, it's removing whitespace too ...
<7> and since it could take loner to roll back than it did to the do the update, we could be waiting for a while
<6> each line is 201 bytes ... but the data is only about ... oh, gee ... 10-20 bytes
<7> yeah its chewing up diskspacep retty quick too, about 1 gig every 2 hours
<6> retarded
<7> i dont know if a reboot will fix anything though, it might try to finish the rollback when it reboots
<3> should have used some other ****ty product that has just as many bugs and is as or more expensivelypriced
<3> lol
<6> hrm, I wonder if there's a way to tell SQL Server 2k to use no row-delimiter ...
<3> lol _zoul_ it will probably do what iis logging does then
<3> just insert like 3k worth of whitespaces randomly all in one blob
<6> right now, it is set to use {CR}{LF} ... but I want it to use <none> ... <none> is a valid Text Qualifier and Column Delimiter ... but not a row delimiter
<6> Arrakis, why do you keep equating this to logging? haha ... it's a DTS package that generates a text file from the database
<3> :P
<6> right now, the package is setup to use fixed-width columns, with {CR}{LF} row delimiter ...
<3> _zq [Shrike] STOP SPOILING MY FUN
<3> LOL
<3> _zoul_
<3> autotabstrikesagain
<6> I told it to use Delimited columns, with no text qualifier or delimiter ...
<6> so that should reduce the output size, as it won't spit out 201 bytes for each record ...
<8> I'm having a really weird issue here
<8> if i ..
<6> if you ...
<8> paste my stored procedure into query analyzer (sql server 2000), it runs fine
<6> spit it the **** out ...
<8> (sorry :P)
<3> mooooooooooooooo FLUYFFFFFFFFFFFFFYYYYYYYYYYY
<8> but if I try to exec storedprocedure or call it, it doesn't
<3> "does" what?
<8> (normally I'd type faster but I'm stuck in a wrist brace today)
<3> *doesnt what?
<8> doesn't run, it just sits there and times out
<8> but the query in the stored procedure runs just fine when it's in query analyzer by itself
<8> it just doesn't run from the stored procedure
<9> moofluffy: try outputting things in the stored proc
<9> see what point it gets to and whatnot
<9> the old school debugging methods
<10> enable tracing
<3> lmao
<3> OLD SKOO
<3> Halo_Four
<8> hehe
<9> Halo_Four: o sure if you want to get into fancy stuff like that :)
Return to
#sql
or
Go to some related
logs:
#delphi
ladderhosen
dns fording
#beginner
#beginner
scool-movies
#gentoo
#beginner
WAITING FOR LOCK PORTAGE_LOCKFILE
#beginner
|
|