Identity column

Question

Identity column

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

noeld SSC Guru Points: 96590 More actions · Answer 1

mailsar (6/4/2008)
Hi noel,
I appreciate your suggestion.What do you mean by publication management issues?
Thanks,
Kayal

Depending how you configure your publication you can come across several "unexpected" things like system stored procedures that are called which you were not expecting; failover procedures are also dependend on some publication settings and if on top of that you have to do this kind of stuff accross many DB and many Servers; simplicity becomes "important".

* Noel

Manie Verster SSCertifiable Points: 7152 More actions · Answer 2

If you made up your mind that's good because you are the one that will have to live with it. There are times when an identity column works and times when your own sequential column works better. If you are not worried about gaps then identity works well but some clients do't like gaps in their sequential numbers then you have to do your own thing.

:-PManie Verster
Developer
Johannesburg
South Africa

I can do all things through Christ who strengthens me. - Holy Bible
I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)

pduplessis-723389 SSChampion Points: 10599 More actions · Answer 3

I have a really simple question for my half a braincell which has never been exposed to replication.

Can anyone explain why the gaps appear in identity columns. I really dont care, but just really curious what leads to the gaps (without the obvious being the delete statement being issued)

~PD

Jeff Moden SSC Guru Points: 1004302 More actions · Answer 4

Yes... it's so the system doesn't have to wait until your insert is done before anyone else can do an insert. If your insert fails (or you change your mind) and is rolled back, gaps occur because the ID's had already been reserved.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

pduplessis-723389 SSChampion Points: 10599 More actions · Answer 5

Ahhhhhh that makes sense and explains quite a lot.

Thanks

~PD