| |
| |
| |
|
Page: 1 2 3 4
Comments:
<0> somethings really ****ed *sigh*
<0> ok I think I know whats going on
<0> Sub quiries aparently are really ****y in 2006
<0> er 2005
<1> are they?
<0> and it doesn't like table variables as much as temp tables
<1> is that a technical term?
<0> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=314874&SiteID=1
<0> really ****ty?
<0> sure, why not?
<1> you make it really hard to help you
<1> i'm out
<2> so you have 3 idiots who dont know how to code posting to a forum whining because they dont know how to tune code...
<2> and you think that makes it fact?
<3> Odyss3us : the solution is to hire a qualified dba
<0> yes!
<0> fixed
<0> changed to temp tabs and there was a couple functions that were doing nasty things so I broke them out into an update
<3> ?
<0> btw thanks for the help everyone
<0> I was in a real ****y mood, it being Saturday evening all and I'm slaving over SQL
<2> yeah and its bad code and bad dba work :P
<0> not really, its hard to really get into the reqs, but there really isn't a better way to do it
<0> it really needs to be in CLR
<4> so you wanted the CLR procs to be fast?
<2> i would say it again.. but theres no point in repeating the facts
<0> in this case I think it would be
<0> hows it going Quant?
<4> not bad. you?
<0> better
<4> you got promoted again?
<0> I had a proc that ran fine in 2k, and wouldn't run in 2k5
<0> not since a couple weeks ago
<4> but you can't have CLR procs on 2k
<4> wait you got promoted a couple of weeks ago?
<0> it's a really nasty TSQL proc
<4> Jarett: whats up
<4> ody: oh i remeber it. it was horrible
<0> yeah, Lead Software Engineer, more money, stock options, etc
<4> i remeber that proc
<2> thats funny...
<4> it was insane
<4> you know why it runs slow on 2k5?
<4> because it hasn't been cached yet :)
<2> the dba
<4> reset cache and run it on 2k, you'll see
<0> actually no
<0> I had to change the table variables to temp tables
<0> which sped it up a bit
<4> table variables should be faster i think
<0> and then I was doing a SELECT DISTINCT fn_Blah(ch.ContactId), and I pulled that out into a UPDATE
<0> went from 5 sec on 2k and >7min on 2k5, to 3 sec on 2k5
<2> yep bad code.. bad dba
<4> hehe
<4> Od, trust me, Jarett would be the first one to say that it's cause MS is ****
<2> No i even tell people running oracle that
<0> it runs in 1sec on prod 2k, I'm hoping it will be under 1sec on 2k5 with these new optimizations
<2> since the leading cause of slow DBs and queries are bad developers and dumb dbas
<4> because it's cached
<4> yup
<0> well thats probably because my dev box is a PIII 1Ghz, and my prod is a dual xeon 2.4
<2> i brought a 9 hour process down to 2.2 tonight :P hopefully down below 1 hour soon
<0> cool
<5> shame on you
<5> i'd do it in 5 minutes
<2> all because of bad developers
<2> people like darken
<5> you're the one with 9 hours guy
<4> darken never sleeps
<5> and 2 hours
<5> i do it in 5 minutes what it takes you 2 hours to do
<2> it was 25 in the past
<5> 5 < 25, you still lose
<5> quant i sleep with the keyboard tied to my hands
<5> so i can write random messages
<6> Quick question. When you set a field type of timeStamp in MSSQL 2005, how do you set the value?
<7> you don't
<6> So it auto sets when you insert a row?
<6> I returned the rows and it shows <Binary data> which i dont quite now how to interpret...
<7> it's an 8-byte binary; think of it as a row version
<6> So what can i do with it? Im thinking maybe ill change the type to nvarchar(20) or so, and manually put a date time that i can actually use...
<7> if you want to use datetime, use datetime, not nvarchar(20)
<6> well, actually im gonna try date time first ;)
<6> Yeha
<6> Tnx ;) And i dont se that right? it sets itself on new row?
<7> what is it that you want to achieve? That determines the appropriate action
<6> More or less, just date and time...
<7> yes, timestamp on MSSQL 2005 is set automatically
<7> you want datetime, then
<6> Im wanting that only when its first created.
<6> Do i have to set it then?
<4> put getdate() into default property of the field
<6> Ahh okay. Then the last question is, I can update the row, and it wont update the date correct?
<4> nope
<6> Great, tnx TheGamble and Quant.
<4> use smalldatetime prolly
<6> Whats the diff?
<4> less space :)
<6> ?
<4> look it up wtf
<5> you lose precision
<7> heh
<7> Let's get some of these channel mofo's to the Conference tomorrow!! W00T
<5> in orlando? no thanks
<5> probably blows
<6> i live in orlando ;)
<6> in near UCF
<5> then you should go even if it blows
<6> i know nothing about it... lol
<6> All it says is a time.. no location or url or anything
<5> now you know something about it
<5> find it
<6> lol
<5> i'm not laughing
<6> i am
<6> i have no real interest...
<7> >:|
<5> if you don't want shot
<5> you'll go
<6> hah
<5> there is your motive
<7> this, coming from the same person who doesn't understand the basic datatypes
<6> i just never used datestamp timestamp
<6> and sdatetime or whatever they all are
<7> as I was saying :)
<6> Doesnt mean i dont understand all of them... lol
<6> and yes smalldatetime is what i need
<6> ou8ch thats out of my price range even if i wanted to go... lol
<7> I'm hopping the plane tomorrow morning; any excuse to get to Florida
<6> hah ;)
<6> When you live hear, its not all that great...
<7> I lived there for 15 years; it's fine
<6> never said it was bad...
<7> Where do you live?
<6> Orlando. Near UCF
<6> Technically Maitland
<7> Thought maybe you'd say Lakeland
<6> ahh nope, sry... im just vaguely familiar with lakeland
<7> just kidding
<6> ive been here 7 or 8 years now...
<7> where you from?
<6> I was born in CA
<6> but ive lived in a few states..
<8> i want to create the tables for a addressbook that will have folders for entrys. i could link entrys to the folder they belong to AND to the address book. OR...i could link the entrys only to their folder. which way is this usually done?
<7> does the database support multiple address books?
<9> i need to consolidate http://sql-servers.com/nopaste/?show=500 into one query if possible, anyone have any ideas?
<7> http://sql-servers.com/nopaste/?show=502
<7> all that was needed was to consider the values used in the 2nd query as being the result of the expressions contained in the first
<9> ahh, yup, thanks, works great
<7> ok
<8> TheGamble: yes it would support multiple address books
Return to
#sql
or
Go to some related
logs:
#debian
#computers
#beginner
kazztaur dizee
msncenter
satx.res.rr.com
#fedora
#firebird
#debian
HI-JOIN
|
|