July 22, 2010 at 2:19 pm
jcrawf02 (7/22/2010)
...and now for something completely different:not sure if that's a good thing or not?
I've done something similar with Chess (+ more than a dozen different rule variants), Backgammon and a few other games for awhile. Works well to keep in touch with friends/family who live far away. I haven't done Risk, but have done Axis and Allies - that was a blast, particularly since I didn't have to set up all the little pieces and keep them out of reach of the small tykes.
Chad
July 22, 2010 at 2:37 pm
I'm done with indexes and games for today. No BBQ, but I did make some gazpacho today.
July 22, 2010 at 2:50 pm
Steve Jones - Editor (7/22/2010)
I'm done with indexes and games for today. No BBQ, but I did make some gazpacho today.
Oh yeah, three days in a row where BBQ was brought up. We like that topic.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 22, 2010 at 3:11 pm
Steve Jones - Editor (7/22/2010)
I'm done with indexes and games for today. No BBQ, but I did make some gazpacho today.
Oooooooooooo!!! I love gazpacho!!!
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
July 22, 2010 at 3:12 pm
Chad Crawford (7/22/2010)
jcrawf02 (7/22/2010)
...and now for something completely different:not sure if that's a good thing or not?
I've done something similar with Chess (+ more than a dozen different rule variants), Backgammon and a few other games for awhile. Works well to keep in touch with friends/family who live far away. I haven't done Risk, but have done Axis and Allies - that was a blast, particularly since I didn't have to set up all the little pieces and keep them out of reach of the small tykes.
Chad
Try to find an online server for "Diplomacy". Similar in concept to Risk, but no luck is involved. Only one turn per day, but everyone moves at once. Rules are fairly simple and all the skill is in the negotiating between turns.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 22, 2010 at 3:47 pm
Tom.Thomson (7/22/2010)
And I agree with Paul' comment - the concept of "heap" as a type of index is amazing. I didn't know whether to puke or laugh or cry when I saw it proposed.
Again, please look where that came from. That's a list of the possible values for the type_desc column in sys.indexes, and there has to be an entry in there for a table that doesn't have a clustered index.
I wouldn't call a heap an index (it's more the lack of an index), but if we're going to quote from BoL to define a number for the types of indexes, there's more than one 'official' answer depending which page you quote from.
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
July 22, 2010 at 3:54 pm
The Dixie Flatline (7/22/2010)
Try to find an online server for "Diplomacy". Similar in concept to Risk, but no luck is involved. Only one turn per day, but everyone moves at once. Rules are fairly simple and all the skill is in the negotiating between turns.
That's one I haven't played, but I'll take your question as a recommendation and put it on my list. Google shows a few places to play, but I don't know which (if any) are good.
I've done chess (and dozens of quite fun variants - Shogi, Caïssa Britannia, Chinese Chess) at http://www.chessvariants.com/
Chess, Backgammon, Stratego, Scrabble, Go, Hex (and variant rules for each) at http://itsyourturn.com/
Pandemic, Dominion, Carcassone, Puerto Rico, and a dozen others at http://brettspielwelt.com/
ItsYourTurn has a dark chess variant - you can only see the squares your pieces can directly attack. They never see your knight coming, but he kind of wanders around not knowing who is coming after him either. 😛
Chad
July 22, 2010 at 4:32 pm
Anyone want to add 2 cents here?
http://www.sqlservercentral.com/Forums/Topic956921-145-1.aspx
OP wants to truncate log and shrink DB straight after an index rebuild. Don't have patience for this tonight.
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
July 22, 2010 at 4:48 pm
The Dixie Flatline (7/22/2010)
Try to find an online server for "Diplomacy". Similar in concept to Risk, but no luck is involved. Only one turn per day, but everyone moves at once. Rules are fairly simple and all the skill is in the negotiating between turns.
I played that game for a high school class and had a lot of fun but I'm wondering how it would translate online. Part of the whole fun was predicting who would screw you based on your prior knowledge of them as a person. I guess it's kind of why I love poker but will never play online.
It is a fun game though ... a certain aspect of what makes Risk so fun without the tediousness.
July 22, 2010 at 5:05 pm
bteraberry (7/22/2010)
The Dixie Flatline (7/22/2010)
Try to find an online server for "Diplomacy". Similar in concept to Risk, but no luck is involved. Only one turn per day, but everyone moves at once. Rules are fairly simple and all the skill is in the negotiating between turns.I played that game for a high school class and had a lot of fun but I'm wondering how it would translate online. Part of the whole fun was predicting who would screw you based on your prior knowledge of them as a person. I guess it's kind of why I love poker but will never play online.
It is a fun game though ... a certain aspect of what makes Risk so fun without the tediousness.
I've played two games in my life - one at a job a few years back, and one online about a year ago. Both quite fun. The online server I used was http://www.playdiplomacy.com/. Anyone up for a game?
July 22, 2010 at 5:44 pm
WayneS (7/22/2010)
Grant Fritchey (7/22/2010)
WayneS (7/22/2010)
How does one go about creating a connect item? I think I've got about a dozen to submit on indexes.....It's not hard. Go to connect.microsoft.com and follow the prompts.
For those so inclined, the first one is up at https://connect.microsoft.com/SQLServer/feedback/details/577460/documentation-types-of-indexes
And this one is for the index structures. https://connect.microsoft.com/SQLServer/feedback/details/577525/documentation-index-structures-listed-in-bol-are-incorrect
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
July 23, 2010 at 4:15 am
Ray K (7/22/2010)
Uh oh, bad blood starting to break out here . . .
Nah, the guy's taking a beating for something he didn't create. I know the feeling all too well. He might be starting to overreact but I think he took a few unnecessary shots.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 23, 2010 at 4:16 am
WayneS (7/22/2010)
Grant Fritchey (7/22/2010)
WayneS (7/22/2010)
How does one go about creating a connect item? I think I've got about a dozen to submit on indexes.....It's not hard. Go to connect.microsoft.com and follow the prompts.
For those so inclined, the first one is up at https://connect.microsoft.com/SQLServer/feedback/details/577460/documentation-types-of-indexes
Yep. I voted too.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 23, 2010 at 7:08 am
Grant Fritchey (7/23/2010)
Ray K (7/22/2010)
Uh oh, bad blood starting to break out here . . .Nah, the guy's taking a beating for something he didn't create. I know the feeling all too well. He might be starting to overreact but I think he took a few unnecessary shots.
I did not post there since I was not sure what I was going to post would be stupid or not. The OP states that when he changed to temp table, it ran faster and then it bogged down again. For me that feels like he has quite a bit of memory pressure and is doing loads of paging. His output is over 30 million rows. That would also mean that he is going to have lots of IO bottle neck. You can do as much tuning on that but that stored proc will always have problem if it has to out put that much rows.
Am I being stupid or am I correct?
-Roy
July 23, 2010 at 7:09 am
WayneS (7/22/2010)
WayneS (7/22/2010)
Grant Fritchey (7/22/2010)
WayneS (7/22/2010)
How does one go about creating a connect item? I think I've got about a dozen to submit on indexes.....It's not hard. Go to connect.microsoft.com and follow the prompts.
For those so inclined, the first one is up at https://connect.microsoft.com/SQLServer/feedback/details/577460/documentation-types-of-indexes
And this one is for the index structures. https://connect.microsoft.com/SQLServer/feedback/details/577525/documentation-index-structures-listed-in-bol-are-incorrect
Thanks Wayne, keep us posted as you add others.
---------------------------------------------------------
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 - 16,666 through 16,680 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply