I read a post that not to use identity as the primary key. and that if you had several tables in your database with identity primary key they will be fighting to get the one.
I was confused when I read this post. So I want to make sure that using identity as primary key on several tables in my database will not affect the performance The second part of my question is if I have a huge huge number of questions is it ok to use integer or should i go for long integer Thanks
No, there is no contention for identity values among multiple identity columns. Define huge...if huge is more than 2 Billion, then you probably want to consider bigint.
>> if you had several tables in your database with identity primary key they will be fighting to get the one Was that sql server?
>> if I have a huge huge number of questions is it ok to use integer or should i go for long integer Depends on what you mean by a huge number. If you are going to hit the int limit then use bigint.
========================================== Cursors are useful if you don't know sql. SSIS can be used in a similar way. Beer is not cold and it isn't fizzy.
How to keep away from using identity column
Posted - 11/08/2012 : 12:46:14
