December 14, 2010 at 11:35 am
Alvin Ramard (12/14/2010)
Stay out of the gutter Gus. It's crowded enough in here without you. π
Trust me, I am WAY below the gutter.
Marianas Trench is uphill from where I usually hang out mentally. :w00t:
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 14, 2010 at 11:41 am
GSquared (12/14/2010)
Alvin Ramard (12/14/2010)
Stay out of the gutter Gus. It's crowded enough in here without you. πTrust me, I am WAY below the gutter.
Marianas Trench is uphill from where I usually hang out mentally. :w00t:
Yeah. I concur. I think Gus would explode from the pressure difference if he came all the way up to the gutter. Wouldn't be pretty. Would be pretty gross. Just like in Outland. SPLAT!
-- Kit
December 14, 2010 at 11:41 am
Wow. I was having problems with an older query taking too long, so I made what I thought was a little switch to begin making time improvements. I changed
FT
INNER JOIN (SELECT TypeID FROM AllTypes WHERE ParentType = 1) T
ON FT.TypeID = T.TypeID
to
WHERE FT.TypeID IN (SELECT TypeID FROM AllTypes WHERE ParentType = 1)
I thought I'd get a decent improvement, but the query went from 2 hours to 5 minutes! I had no idea it would be that dramatic. Thank you SQL Server Saturday where I first learned that concept.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
Itβs unpleasantly like being drunk.
Whatβs so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
December 14, 2010 at 11:50 am
GSquared (12/14/2010)
Alvin Ramard (12/14/2010)
Stay out of the gutter Gus. It's crowded enough in here without you. πTrust me, I am WAY below the gutter.
Marianas Trench is uphill from where I usually hang out mentally. :w00t:
It's nice to know I have good company then. π
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
December 14, 2010 at 11:53 am
GSquared (12/14/2010)
Alvin Ramard (12/14/2010)
I'd prefer a picture of the horse stepping on the iPad. πHow about a horse stepping on an iMat?
With an iMat Michael Flatley surely would have an advantage to write an email... π
December 14, 2010 at 12:27 pm
LutzM (12/14/2010)
GSquared (12/14/2010)
Alvin Ramard (12/14/2010)
I'd prefer a picture of the horse stepping on the iPad. πHow about a horse stepping on an iMat?
With an iMat Michael Flatley surely would have an advantage to write an email... π
LOL!! Yeah!
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 14, 2010 at 1:30 pm
GSquared (12/14/2010)
Alvin Ramard (12/14/2010)
Stay out of the gutter Gus. It's crowded enough in here without you. πTrust me, I am WAY below the gutter.
Marianas Trench is uphill from where I usually hang out mentally. :w00t:
I feel you on that one, Gus. I consider the gutter grates to be starlight. About as unreachable for me... and about as distant. π
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 14, 2010 at 1:34 pm
Days like this, I wonder why I even talk to you people. All that gutter-talk coming out of your mouths... My mom would wash all your mouths out with soap! π
(Where's my halo? Self-righteous doesn't work without my halo, darnit!)
π
December 14, 2010 at 1:36 pm
Brandie Tarvin (12/14/2010)
Days like this, I wonder why I even talk to you people. All that gutter-talk coming out of your mouths... My mom would wash all your mouths out with soap! π(Where's my halo? Self-righteous doesn't work without my halo, darnit!)
π
It's okay. You're not talking to us. You're typing at us.
Does that mean your mom's willing to wash my keyboard out with soap?
Or is like the mother with the mute kid, washed his hands out with soap...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 14, 2010 at 1:38 pm
Brandie Tarvin (12/14/2010)
Days like this, I wonder why I even talk to you people. All that gutter-talk coming out of your mouths... My mom would wash all your mouths out with soap! π(Where's my halo? Self-righteous doesn't work without my halo, darnit!)
π
Wash our mouths with soap? Why? We didn't actually say anything bad. π
Brandie, I didn't know what halos came in the shape of toilet seats. π
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
December 14, 2010 at 1:38 pm
Brandie Tarvin (12/14/2010)
(Where's my halo? Self-righteous doesn't work without my halo, darnit!)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 14, 2010 at 1:41 pm
GilaMonster (12/14/2010)
Brandie Tarvin (12/14/2010)
(Where's my halo? Self-righteous doesn't work without my halo, darnit!)
How long did it take you to forge your own halo, in between the lightning strikes, Gail? And... is that... rust?
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 14, 2010 at 1:42 pm
I'm so glad I don't have a drink in my hand right now. All three responses just made my day.
@=)
December 14, 2010 at 1:45 pm
Brandie Tarvin (12/14/2010)
GilaMonster (12/14/2010)
Want some entertainment? I give you Gus's reply here http://www.sqlservercentral.com/Forums/FindPost1034345.aspx, nominated for comment on the week.It almost resulted in coffee over laptop.
I can see why. @=) I'll second that nomination!
That is great.
December 14, 2010 at 1:46 pm
Craig Farrell (12/14/2010)
GilaMonster (12/14/2010)
Brandie Tarvin (12/14/2010)
(Where's my halo? Self-righteous doesn't work without my halo, darnit!)How long did it take you to forge your own halo, in between the lightning strikes, Gail? And... is that... rust?
I liked Halo, but not Halo II. Haven't played much Reach. :hehe:
Viewing 15 posts - 22,411 through 22,425 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply