Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


theSystem


theSystem

Author
Message
FibRock
FibRock
SSC Veteran
SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)

Group: General Forum Members
Points: 230 Visits: 257
Comments posted to this topic are about the item theSystem

Steve
http://stevefibich.net
http://utilitydb.codeplex.com/
Ian Yates
Ian Yates
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1058 Visits: 445
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! BigGrin



Tom Garth
Tom Garth
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1015 Visits: 1499
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

FibRock
FibRock
SSC Veteran
SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)

Group: General Forum Members
Points: 230 Visits: 257
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/
timothyawiseman
timothyawiseman
SSC Eights!
SSC Eights! (806 reputation)SSC Eights! (806 reputation)SSC Eights! (806 reputation)SSC Eights! (806 reputation)SSC Eights! (806 reputation)SSC Eights! (806 reputation)SSC Eights! (806 reputation)SSC Eights! (806 reputation)

Group: General Forum Members
Points: 806 Visits: 920
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/
Stephen E. Cook
Stephen E. Cook
SSC Eights!
SSC Eights! (863 reputation)SSC Eights! (863 reputation)SSC Eights! (863 reputation)SSC Eights! (863 reputation)SSC Eights! (863 reputation)SSC Eights! (863 reputation)SSC Eights! (863 reputation)SSC Eights! (863 reputation)

Group: General Forum Members
Points: 863 Visits: 818
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
Sreejithsql
Sreejithsql
Right there with Babe
Right there with Babe (777 reputation)Right there with Babe (777 reputation)Right there with Babe (777 reputation)Right there with Babe (777 reputation)Right there with Babe (777 reputation)Right there with Babe (777 reputation)Right there with Babe (777 reputation)Right there with Babe (777 reputation)

Group: General Forum Members
Points: 777 Visits: 134
hi Steve ,
wahoooo amazing... eagerly wating for ur next series.thx for ur informations.

thx
Sreejith
MCAD
spacefacial
spacefacial
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 0
really interesting ... one thing tho, maybe you could explain some more about the game itself ... or did I miss that?
Wayne West
Wayne West
SSCommitted
SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)

Group: General Forum Members
Points: 1544 Visits: 3694
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. BigGrin

-----
Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search