May 28, 2009 at 2:14 pm
Alvin Ramard (5/27/2009)
Bob Hovious (5/27/2009)
What's an index?It's one of your fingers.
No, not that one!! the one next to it!! Jeesh . .. :hehe:
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
May 28, 2009 at 2:17 pm
GilaMonster (5/28/2009)
I thought I'd seen everything....Anyone (preferably someone who's telepathic or precog) want to tackle these?
Wow!
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
May 28, 2009 at 2:18 pm
Roy Ernest (5/28/2009)
I liked the thread about the table Status.... 😀
Both of them are about that same table. I liked it when the guy said the table was part of SSMS.
- 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
May 28, 2009 at 2:19 pm
Tom Brown (5/27/2009)
Gaby Abed (5/27/2009)
Jack Corbett (5/27/2009)
Discussing this, just in jest will get the thread to 5000 posts pretty quickly.
Hmmm...a challenge? Who will be the 5000th post?
Will there be a prize? 😀
The lucky 5000th will be granted authorship of the index book 😀
Thank God I missed catching up with you guys till after you passed the mark 😉
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
May 28, 2009 at 2:19 pm
Bob Hovious (5/28/2009)
Nope that would only add excitement to baseball if you were allowed to clock the 1st baseman in the ribs to make him drop the ball as he was catching it.
Of course if that was the case you'd probably need to carry more fielders than pitchers for the first time in a long time. You know every so often someone would take a bat to the back of the head. Ouch.
So we armor up the guys in the infield with flak jackets, pads and helmets, and then let them physically block the runners from touching the bases......
This is promising $!$!$ 😀
Basebrawl. Mad Magazine had an article about it in the '70s. Was entertaining then too.
- 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
May 28, 2009 at 2:26 pm
Gaby Abed (5/28/2009)
GilaMonster (5/28/2009)
I thought I'd seen everything....Anyone (preferably someone who's telepathic or precog) want to tackle these?
Wow!
Reminds me of the Four Candles sketch by the Two Ronnies
May 28, 2009 at 2:31 pm
Anyone (preferably someone who's telepathic or precog) want to tackle these?
Limited precognition is actually one of my mutant powers, Gail. Having looked at that thread I had a sudden glimpse of the future that told me I would NOT be trying to help that OP. 😉
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 28, 2009 at 2:41 pm
Paul White (5/27/2009)
Right then.Given the wealth of knowledge and talent around these parts, who's up for writing the perfect collaborative-effort book on indexing?
We could all get fabulously rich!!! :w00t:
Paul
There's gonna be a queue behind you on this one, Paul. Wait a minute..."W"...you're gonna be somewhere near the end.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
May 28, 2009 at 2:43 pm
Bob Hovious (5/28/2009)
Limited precognition is actually one of my mutant powers, Gail. Having looked at that thread I had a sudden glimpse of the future that told me I would NOT be trying to help that OP. 😉
😀 :hehe:
I believe I'm going to exercise the greater part of valour, and make a strategic retreat from both of those threads.
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
May 28, 2009 at 2:50 pm
GilaMonster (5/28/2009)
I thought I'd seen everything....Anyone (preferably someone who's telepathic or precog) want to tackle these?
Gail, how are you lucky enough to find all these wonderful folks???
-- You can't be late until you show up.
May 28, 2009 at 2:52 pm
GilaMonster (5/28/2009)
I thought I'd seen everything....Anyone (preferably someone who's telepathic or precog) want to tackle these?
Unfortunately, sunspot activity is currently inhibiting my psionic abilities, so I can't help the poster, but being the curious type, I did try to find some way to get 12:16pm with 56 secs from 1243012622. No luck, but an interesting thing:
12:16:56 = 44216000 milliseconds since prior midnight
1243012622 / 44216000 = 28112.28112
Spooky.
May 28, 2009 at 2:57 pm
Dave Smith (5/28/2009)
GilaMonster (5/28/2009)
I thought I'd seen everything....Anyone (preferably someone who's telepathic or precog) want to tackle these?
Unfortunately, sunspot activity is currently inhibiting my psionic abilities, so I can't help the poster, but being the curious type, I did try to find some way to get 12:16pm with 56 secs from 1243012622. No luck, but an interesting thing:
12:16:56 = 44216000 milliseconds since prior midnight
1243012622 / 44216000 = 28112.28112
Spooky.
he might have made a mistake ....
60*0.43=25.8
12:26 sounds mire reasonable, that assuming I know what's going on.
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]
May 28, 2009 at 2:58 pm
jcrawf02 (5/28/2009)
Tom Brown (5/27/2009)
Lynn Pettis (5/26/2009)
OMG, you really have to be kidding here...As a complete and totally unrelated aside: -
There's a character called Trigger in the BBC comedy Only Fools 'n' Horses http://www.bbc.co.uk/comedy/onlyfools/uncovered/trigger.shtml
Why 'Trigger' - I always thought it was because he was sooo intellectually quick witted.
Trigger was Roy Rogers' horse, that was my first thought on seeing the title of the show.
According to Wikipedia, the character in Only Fools 'n' Horses was named Trigger because he apparently looked like a horse. Can't judge that one as I haven't seen the show, but that's what Wikipedia says (and we ALL know that Wikipedia is NEVER wrong... most of the time...)
-- Kit
May 28, 2009 at 2:59 pm
tosscrosby (5/28/2009)
GilaMonster (5/28/2009)
I thought I'd seen everything....Anyone (preferably someone who's telepathic or precog) want to tackle these?
Gail, how are you lucky enough to find all these wonderful folks???
Steve, quote button no worky, I was trying to quote this:
GilaMonster (5/28/2009)
--------------------------------------------------------------------------------
I thought I'd seen everything....
Anyone (preferably someone who's telepathic or precog) want to tackle these?
http://www.sqlservercentral.com/Forums/Topic725415-8-1.aspx
http://www.sqlservercentral.com/Forums/Topic725410-8-1.aspx
Unfortunately, sunspot activity is currently inhibiting my psionic abilities, so I can't help the poster, but being the curious type, I did try to find some way to get 12:16pm with 56 secs from 1243012622. No luck, but an interesting thing:
12:16:56 = 44216000 milliseconds since prior midnight
1243012622 / 44216000 = 28112.28112
Spooky.
which, it appears, might maybe be helpful.
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
May 28, 2009 at 3:03 pm
Kit G (5/28/2009)
jcrawf02 (5/28/2009)
Tom Brown (5/27/2009)
Lynn Pettis (5/26/2009)
OMG, you really have to be kidding here...As a complete and totally unrelated aside: -
There's a character called Trigger in the BBC comedy Only Fools 'n' Horses http://www.bbc.co.uk/comedy/onlyfools/uncovered/trigger.shtml
Why 'Trigger' - I always thought it was because he was sooo intellectually quick witted.
Trigger was Roy Rogers' horse, that was my first thought on seeing the title of the show.
According to Wikipedia, the character in Only Fools 'n' Horses was named Trigger because he apparently looked like a horse. Can't judge that one as I haven't seen the show, but that's what Wikipedia says (and we ALL know that Wikipedia is NEVER wrong... most of the time...)
Wikifrickintastic! That childhood cooped up in the house and tortured with Singing Sandy, Roy Rogers and the Sons of the Pioneers finally pays off. Jackpot!!!
it's all downhill from here . . .
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
Viewing 15 posts - 5,086 through 5,100 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply