| |
| |
| |
|
Page: 1 2 3 4 5 6 7
Comments:
<0> 80% of the code i work with daily is java... if it were up to me it would be a much smaller %
<0> but hey.. gotta do what i gotta do
<1> there's a lot of hype about loose datatypes being the way of things in the future
<2> Yes, the wave of the future, if it's 1965.
<1> um, no
<0> sort of like .net is the future of programming... if its 1994 and vb6
<2> Two most widely used business programming languages are VB6 and Java.
<3> Jarett_, the recent sun java creator IDE is an exact copy of vs.net full with codebehind, same standard controls to drag from the toolbox onto the designer that you see in vs2k5
<1> having sat through this entire conversation, i actually think i can feel my penis getting smaller
<0> dfworking, come on. enjoy it. its funny
<0> especially since halo thinks its all serious
<2> Nah, I stopped taking you seriously about the time you mentioned that you slop in PHP.
<0> plus any self respecting coder would only use eclipse or oracle jdev.
<3> :|
<2> Self respecting "coders" would drag magnets over hard drive platters
<0> ummm magnets run hard drives
<0> so yes.. they would
<2> Manually
<0> why do something manually when its done automatically?
<0> you are stuck in MS mentality
<2> Because leet people wouldn't use an IDE, particularly to code their PHP
<2> It's too drag&drop.
<0> i use ultraedit when i code php
<0> or of course vi
<3> no, computers are made to do your work for you, dont need to be doing some tasks that can be easily automated
<3> invest your time in the real functionality of your apps
<0> kal-EL_, at.exe is way way too hard for the likes os many .net drag and droppers
<3> do you have a car Jarett_ ?
<3> hehe
<3> or you prefer to walk to work everyday
<3> hehe
<0> yeah i bought it from a dead lady
<0> i put 100 miles a day on it. i needed a beaterupper
<3> maybe you can come to visit me in italy some day and i can buy a beer, please come walking
<3> hehe
<0> i dont like beer
<3> is there anything you like :|
<0> hard cider or other stuff
<0> beer is like drinking dirt that makes you fat
<4> Jarett_ are you bored? stop embarrasing yourself and get some work done for christs sake
<0> Rizard^, i am getitng work done
<4> no youre not, youre in here running your mouth
<0> yep and im also getting work done
<4> acting a damn fool too
<4> man whatever, you sound like some aol kid that just got a helpdesk job
<4> its clear to everyone you have no idea what the **** youre talking about
<0> when you learn not to do everything manually, you get much more accomplished
<4> these guys make twice or 3 times what you do
<0> Is it that clear?
<3> after a long walk from the states to italy, he turned down a good beer :-(
<0> really?
<4> youre a kid.
<4> scram.
<0> they make that much more?
<0> as el33t .net coders ;P
<0> and access monkeys
<1> what do you make Jarett_
<0> enough
<4> case closed.
<1> well i make MORE than enough, so i earn more
<0> people who need to discuss how much they make are sad and sorry people
<1> indeed
<1> i have other problems as well
<0> Rizard^, what do you make?
<1> currently i'm winning with 'more than enough'
<1> just trying to set the bar
<0> I lean on God to provide for all my needs
<0> Thats good enough for me
<1> christ
<0> Yes Him
<1> he sure didn't bail you out on that 'great personality' thing did he
<0> Im a work in progress
<1> sky=blue
<0> Depends on the time of day
<4> Bet jarett sports a mullet
<4> a sweet mullet
<0> nope
<0> Im not allowed to have a mullet, since i dont like beer
<0> mullets = rednecks = likes beer
<1> [mullets = rednecks = likes beer] = god's children
<0> not really
<1> just like .... you!
<3> nobody understand Jarett_, not his friends, not his girlfriend and nobody here :-(
<0> s/girlfriend/wife/g
<3> :p
<0> or in .net terms... click click click click click find & replace click girlfriend click ignore case click wife click replace all
<0> crash/.. reboot
<5> i get a db2 error with sqlcode -912 and sqlstate 57011, looks like a deadlock issue. it suggests to increase the locklist db parameter. anyone know where i can do this?
<0> JohnD, how much available memory is on th ebox?
<5> should be 2gb
<0> JohnD, issue this command: db2 get db config for (dbname)
<5> ok, what should i look for?
<0> whats your locklist setting?
<5> 50
<0> ok you can set that higher if you have more memory available.
<0> db2 -v update
<0> db cfg for (dbname) using LOCKLIST 100
<0> db2 -v terminate
<0> what was your locktimeout and maxlocks settings?
<0> but you should check out your commits or rollbacks instead and tune your application
<5> i am in the command line utility now
<5> not at the dos prompt
<5> if i try "db2 .." i get "command line environment not initialized"
<0> didnt it just wok before with the get?
<5> yeah i did "get db config for database"
<5> what does -v update and terminate do?
<0> try: update db cfg for database using locklist 100
<5> sweet, worked.. thanks!
<0> bump up your maxlocks and locktimeout too
<0> if they arent too high
<5> but, i have just restarted the db after a large transaction that failed. is it possible that some locks are there after the reset?
<0> was it done rolling back?
<0> it shouldnt be holding locks after a restart if there is no corruption
<5> okey.. i am not sure whether it rolled back correctly
<0> i hate that about some people that use my systems. they see a super long transaction they run, and think killing it out will immediately solve the performance issue... when in fact it compounds the problem since there is a rollback which will take just as long or longer of the original transaction
<0> Rizard^, want to chime in on the topic?
<5> looks like it works again! thanks a bunch jarett
<6> let me ask a really stupid question, in sql 2k5 i'm receiving a table name in a variable, what is the 'best' way to receive a record count for that table? right now, i'm using dynamic sql to exec into a temptable... there has to be a better way!
<0> no problem
<0> all you want to do is count the table?
<6> into a varaible
<6> SET @TableRowCount = ..
<0> you want all rows in a variable or just the count?
<6> just the count
<0> cant you just select rowcnt from sysindexes where object_name(id)='@tablenamevar'?
<6> prolly?, let me try
<0> thats not perfect due to what your indexes are
<6> hmm, i'd need to pull in the PK
<2> If there is a clustered index it should be.
<6> that's not a problem though
<7> Hey, I'm having problems with create a sub query, mostly I think I'm out of practice
<7> I've got one query that pulls the inital information
<2> SET @sql = 'SELECT @Count = COUNT_BIG(*) FROM ' + QUOTENAME(@TableName); EXEC sp_executesql @sql, @parameters = N'@Count BIGINT OUTPUT', @Count = @Count OUTPUT; PRINT @Count;
<7> but I need to pull prices for each item on that list
<2> That would work and would be independent of indexes.
<7> (I can't use a simple join because of the way the tables have been setup)
<7> http://sql-servers.com/nopaste/?show=288
<7> are the two queries I'm using
<7> but I can't stitch them together, so any help would be very grately appreciated (mssql)
<6> Halo_Four: thanks, i'll take a look at that
<0> Rizard^, thanks for chiming in and helping... way to backup a aol kid ;)
<6> Halo_Four: thanks again, looks good
<1> does anyone have any cottage cheese?
<3> very nice Jarett_, atleast you know your stuff in sql so "no comment" ;p
<8> morning all folks
<0> that wasnt sql though
<3> dont be modest now :-)
<0> im not. but that as dba not sql
Return to
#sql
or
Go to some related
logs:
#mirc
#gentoo
#sex
defenition: ident
actionscript geturl popup blocker
#beginner
Flash scroll images endless loop
AMAME AMD
compiz: GLX_EXT_texture_from_pixmap is missing tnt
#flash
|
|