Re: Data model for a web messaging application.
Date: 5 Oct 2004 06:19:04 -0700
Message-ID: <429f6e7d.0410050519.28073d82_at_posting.google.com>
Uri, John and especially David! Thanks for the code review; I am now
one step further :)
"John Bell" <jbellnewsposts_at_hotmail.com> wrote in message news:<41605341$0$21630$afc38c87_at_news.easynet.co.uk>...
> There is probably a
"Covering index" is something I lack to understand ... How is it
stored in a
> natural key of RecipientID, SenderID, and SubmitDate so a covering unique
> index may be useful, and a INT may not be sufficient for you messageid.
b-tree structure, does the whole string composed of the diffrent
columns get saved as one key in each node? How does SQL server
(depending on the query's' where clause of course) 'extracts' the
right column and scan for its appropriate value within the index? What
I thought about using a uid, but they are not suitable for a Clustered
Index since they are not guaranteed to be chosen in incremental
order...
Thanks again
-Itai
BTW does anyone know how to dump a table to a text file using command
line with arguments?