Gustav Brock
gustav at cactus.dk
Thu Dec 18 11:39:35 CST 2003
Hi Susan By second (forth?) read I now understand: >> Microsoft discourages the use of GUID as a primary key, but that's >> because most people don't really need universal uniqueness. When >> uniqueness across many systems is vital, however, the GUID datatype is >> definitely the way to go. Just remember that you pay a price in >> performance. I read this HOLE paragraph as one statement from MS. But it is only the first sentence ... the remaining part of the paragraph is YOUR opinion, right? Sorry. /gustav > I don't remember ever reading that MS suggest using GUID's for primary keys, > but that may be the case. My reference state just the opposite. > Susan H. >> Hi Susan >> >> Oh, you are about to confuse me ... >> >> Steve talked about collecting data from 15 locations. >> You wrote about "uniqueness across many systems" >> And MS is quoted for suggesting that "GUID datatype is definitely the >> way to go" in such a situation. >> >> Then you conclude: >> >> >> > Microsoft recommends that you not use GUID's as primary keys .. >> >> How does that match? >> >> /gustav >> >> >> >> Ehh, Susan ... aren't you (re)reading your own articles too fast: >> >> >> >> <quote> >> >> >> >> Microsoft discourages the use of GUID as a primary key, but that's >> >> because most people don't really need universal uniqueness. When >> >> uniqueness across many systems is vital, however, the GUID datatype is >> >> definitely the way to go. Just remember that you pay a price in >> >> performance. >> >> >> >> </quote> >> >> >> >> Isn't "across many systems" exactly the situation of Steve? >> >> > =============I don't really understand your question? Do you think the >> > statement is wrong? FWIW, I'm not suggesting the article solves anyone's >> > problem. Just linking because it discusses the subject. Arthur may pipe >> > in here later. >> >> >> /gustav >> >> >> >> PS: Nice picture of you and your mother! >> >> > =============Thanks. :) Remember the pic of Ann Landers that was a >> > bazillion >> > years old? Well, she's not the only one that can pull that trick. BTW, >> > that's actually my granddaughter. :) >> >> Perfect! Do I feel lucky?