November 30, 2015 at 2:29 pm
Announcing the front runner for the Crystal Ball Award nomination 2015
😎
NOTE: Please support your favourite CBA by NOT answering the missing questions:-D
November 30, 2015 at 2:33 pm
Eirikur Eiriksson (11/30/2015)
Announcing the front runner for the Crystal Ball Award nomination 2015😎
NOTE: Please support your favourite CBA by NOT answering the missing questions:-D
Yeah that question is so far away from me putting in any effort it might was well be in another solar system.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
November 30, 2015 at 2:39 pm
Alvin Ramard (11/30/2015)
Lynn Pettis (11/30/2015)
Sean Lange (11/30/2015)
robert.sterbal 56890 (11/30/2015)
robert.sterbal 56890 (11/30/2015)
Images:Search:
https://www.google.com/search?q=venn+diagram+left+outer+join
It is redundant, but is used quite frequently:
Yes when doing a LEFT OUTER join the OUTER keyword is optional...but this discussion is about somebody discussing LEFT INNER join which is almost as elusive as a gold pot carrying leprechaun or a flying unicorn. 😀
I am reminded of Jeff Dunham and Peanut.
Anyone know if a RIGHT INNER JOIN performs better than a LEFT INNER JOIN?
In my testing they both out-performed the CROSS OUTER JOIN by almost 200%.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
November 30, 2015 at 2:42 pm
Sean Lange (11/30/2015)
Eirikur Eiriksson (11/30/2015)
Announcing the front runner for the Crystal Ball Award nomination 2015😎
NOTE: Please support your favourite CBA by NOT answering the missing questions:-D
Yeah that question is so far away from me putting in any effort it might was well be in another solar system.
I'm just waiting for someone to pull that trigger. 🙂
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]
November 30, 2015 at 2:57 pm
Alvin Ramard (11/30/2015)
Sean Lange (11/30/2015)
Eirikur Eiriksson (11/30/2015)
Announcing the front runner for the Crystal Ball Award nomination 2015😎
NOTE: Please support your favourite CBA by NOT answering the missing questions:-D
Yeah that question is so far away from me putting in any effort it might was well be in another solar system.
I'm just waiting for someone to pull that trigger. 🙂
Are we counting hen's teeth today as well?
November 30, 2015 at 3:17 pm
Lynn Pettis (11/30/2015)
Alvin Ramard (11/30/2015)
Sean Lange (11/30/2015)
Eirikur Eiriksson (11/30/2015)
Announcing the front runner for the Crystal Ball Award nomination 2015😎
NOTE: Please support your favourite CBA by NOT answering the missing questions:-D
Yeah that question is so far away from me putting in any effort it might was well be in another solar system.
I'm just waiting for someone to pull that trigger. 🙂
Are we counting hen's teeth today as well?
Not that I know.
I thought one OP might be counting his teeth earlier today after he thanked Gail for her assware. Turned out he meant answer. 😀
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]
November 30, 2015 at 3:21 pm
Lynn Pettis (11/30/2015)
Alvin Ramard (11/30/2015)
Sean Lange (11/30/2015)
Eirikur Eiriksson (11/30/2015)
Announcing the front runner for the Crystal Ball Award nomination 2015😎
NOTE: Please support your favourite CBA by NOT answering the missing questions:-D
Yeah that question is so far away from me putting in any effort it might was well be in another solar system.
I'm just waiting for someone to pull that trigger. 🙂
Are we counting hen's teeth today as well?
It is dark, there is heavy cloud cover and a new moon. There is noise in front, Shoot!!!
November 30, 2015 at 3:38 pm
I know we are stock piling silver spoons in the Tent in the Desert, but have we found a reliable vendor for crystal balls? Looks like we need to start getting more of them in as well.
December 1, 2015 at 2:08 am
Me: Execution plans please
OP: You can use AdventureWorks2012
Well, yes I could, if I had it installed on the machine that I'm currently using (which I don't). Or I can spend that time on other questions. Guess which it's going to be.
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 1, 2015 at 5:29 am
Lynn Pettis (11/30/2015)
I know we are stock piling silver spoons in the Tent in the Desert, but have we found a reliable vendor for crystal balls? Looks like we need to start getting more of them in as well.
That was quite a thread. It's almost as if the OP just wanted an answer without having to be bothered to provide any detail at all. I guess vague and general answers to vague and general questions are appropriate. In this case, it appeared to make the OP happy as well. Nice job.
The crystal balls are something I could definitely use from time to time. They appear to have a one-shot use though, before disappearing to somewhere else.
December 1, 2015 at 5:32 am
Ed Wagner (12/1/2015)
They appear to have a one-shot use though, before disappearing to somewhere else.
Probably something to do with collapsing the quantum mechanical wave function. Using one collapses the function of possible problems to one, and as a side effect sets the crystal ball's location probability function to a constant across all of space-time.
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 1, 2015 at 5:37 am
robert.sterbal 56890 (11/30/2015)
robert.sterbal 56890 (11/30/2015)
Images:Search:
https://www.google.com/search?q=venn+diagram+left+outer+join
It is redundant, but is used quite frequently:
Nice link. Thanks, Robert.
Heehee.
December 1, 2015 at 5:51 am
GilaMonster (12/1/2015)
Ed Wagner (12/1/2015)
They appear to have a one-shot use though, before disappearing to somewhere else.Probably something to do with collapsing the quantum mechanical wave function. Using one collapses the function of possible problems to one, and as a side effect sets the crystal ball's location function to a constant across all of space-time.
If the location function is a constant, it certainly isn't here. 😛 I think it must use dark matter in some way because when I try to answer some questions, I sure feel like I'm taking a shot in the dark.
December 1, 2015 at 6:08 am
Ed Wagner (12/1/2015)
GilaMonster (12/1/2015)
Ed Wagner (12/1/2015)
They appear to have a one-shot use though, before disappearing to somewhere else.Probably something to do with collapsing the quantum mechanical wave function. Using one collapses the function of possible problems to one, and as a side effect sets the crystal ball's location function to a constant across all of space-time.
If the location function is a constant, it certainly isn't here. 😛
Whoops, I left out the word 'probability'. If something has a constant value for its location probability, there's an equal likeliness that it can be found anywhere. Isn't quantum mechanics fun?
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 1, 2015 at 6:48 am
GilaMonster (12/1/2015)
Ed Wagner (12/1/2015)
GilaMonster (12/1/2015)
Ed Wagner (12/1/2015)
They appear to have a one-shot use though, before disappearing to somewhere else.Probably something to do with collapsing the quantum mechanical wave function. Using one collapses the function of possible problems to one, and as a side effect sets the crystal ball's location function to a constant across all of space-time.
If the location function is a constant, it certainly isn't here. 😛
Whoops, I left out the word 'probability'. If something has a constant value for its location probability, there's an equal likeliness that it can be found anywhere. Isn't quantum mechanics fun?
It sounds like it could be both fun and interesting, but quite honestly, I have no idea.
Viewing 15 posts - 51,646 through 51,660 (of 66,815 total)
You must be logged in to reply to this topic. Login to reply