Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

theSystem Expand / Collapse
Author
Message
Posted Wednesday, January 30, 2008 10:54 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 2:09 PM
Points: 222, Visits: 235
Comments posted to this topic are about the item theSystem

Steve
http://stevefibich.net
http://utilitydb.codeplex.com/
Post #449810
Posted Thursday, January 31, 2008 4:07 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 30, 2014 10:08 PM
Points: 1,038, Visits: 444
I'm looking forward to the rest of the series. It's a nice departure from the usual (although still useful and definitely not mundane) stuff we all read on here.
I will have to correct you about the non-clustered indices though. They don't store the primary key in the leaf nodes. They actually store the clustered index field values in the leaf nodes. Often, or at least by default, the pkey and the clustered index are the same. If they are not the same then you may wonder what would happen if the clustered index is no longer unique... In that case MS SQL actual adds what is called a uniqifier to make the record, as far as the clustered index is concerned, unique. There's an article somewhere on this site which explains it well and in depth.

Apart from that, as I said, I'm looking forward to see how you develop your engine, etc. When I was younger I often wanted to write my own Dune 2000 clone. I never even got as far as you have in your first article! :D



Post #449862
Posted Thursday, January 31, 2008 7:51 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, February 04, 2011 7:20 AM
Points: 977, Visits: 1,499
This is going to be interesting. I'm anxious to see the details on the UI.

Tom Garth


Tom Garth
Vertical Solutions

"There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers
Post #449951
Posted Thursday, January 31, 2008 10:27 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 2:09 PM
Points: 222, Visits: 235
Thanks for the correction; I rely on the primary key being my clustered index close to 99% of the time.

Steve
http://stevefibich.net
http://utilitydb.codeplex.com/
Post #450078
Posted Thursday, January 31, 2008 3:53 PM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, April 04, 2014 4:40 PM
Points: 751, Visits: 917
This is one of the more interesting articles on SQL I've seen so far. I am definitely interested to see the end product.

---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
Post #450229
Posted Thursday, January 31, 2008 5:40 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 12:49 PM
Points: 860, Visits: 800
I created a Black Jack game in SQL Server for kicks (could be multiplayer, with computer-controlled dealer, and you could set the number of decks and a few different rule set variations)... but this is much more ambitious!

I'm looking forward to the rest of the series.



-- Stephen Cook
Post #450249
Posted Monday, February 04, 2008 4:23 PM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Saturday, August 25, 2012 9:48 PM
Points: 777, Visits: 134
hi Steve ,
wahoooo amazing... eagerly wating for ur next series.thx for ur informations.

thx
Sreejith
MCAD
Post #451390
Posted Monday, February 04, 2008 7:09 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 04, 2008 7:07 PM
Points: 1, Visits: 0
really interesting ... one thing tho, maybe you could explain some more about the game itself ... or did I miss that?
Post #451415
Posted Tuesday, July 01, 2008 12:35 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, May 09, 2012 10:26 AM
Points: 891, Visits: 1,958
Very interesting, Steve. I somehow missed this post when it first appeared, very glad the third article was featured in the news letter. I used to work for a play-by-mail game company and always wanted to learn how it worked "beneath the layers", so to speak. Personally, I design card games (and publish one) and use MS Access as the repository, but that's not an interactive system.

I'm really looking forward to your future articles. Oh, and the word is "encounter", not "incounter". Sorry, I'm married to a Grammar Nazi. :D
Post #526861
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse