Re: uniqueidentifier

From: Roji. P. Thomas (lazydragon_at_nowhere.com)
Date: 03/12/04 

Date: Fri, 12 Mar 2004 21:59:57 +0530

>>Does anyone have any response to using an identity?
CELKO might have some! 

-- 
Roji. P. Thomas
SQL Server Programmer
"Hutch" <anonymous@discussions.microsoft.com> wrote in message
news:3BD3D5A0-BD1E-4D54-9D08-B56621552A0C@microsoft.com...
> The table's projected growth is in the 10 - 15 million rows per year
range.  An INT does give me 2 billion plus values so maybe that isn't so
bad. Thanks Andrew, I haven't though of using identity since school.
> Does anyone have any response to using an identity?  In school I remember
only using identity for medium sized tables.
> To make a unique row in my table I would have to use a combination of
seven columns ranging in datatypes of char, varchar, and int this is why I
am looking to use a single key column. I'm thinking the additional space
needed for the key column will make up for the space needed if used the
combined key.  Any thoughts of this philosophy?
>
>
> -Hutch

Relevant Pages

  • Re: Shots Fired at NC Prep School
    ... The school was placed on lockdown, ... students are now being released to their parents. ... Gun laws changed in response - zero. ...
    (talk.politics.misc)
  • [PATCH] Cleanups for the IPMI driver
    ... off the shutdown of the timer when removing the module. ... static int ipmi_init_msghandler; ... * Send a command request from the given user. ... * the message response comes back, the receive handler for this user ...
    (Linux-Kernel)
  • Re: ray nagins incompetance
    ... >>> Ray also had full power to use these buses to evacuate citizens and he ... loose theory that school busses shown in a photo ... response professionals are prepared for any situation. ... to state and local governments (presumably governments "in this part ...
    (alt.politics.bush)
  • Re: OT: "Out of respect for Diana......"
    ... so you don't have any actual response then? ... his day to day life and posts here for a bit of recreational fun. ... He lives of his childrens benefits. ... kids are at school all day - by his own admission so this bullshit ...
    (uk.media.tv.misc)
  • [patch 2/3] s390: add vmcp interface.
    ... Add interface to issue VM control program commands. ... * the caller of __cpcmd has to ensure that the response buffer is below 2 GB ... +static int vmcp_open ...
    (Linux-Kernel)