![]() Another trick with int or bigint is to start the seed at the largest negitive number. Also, for those worried about running out of numbers they can use bigint with identity and hold 9,223,372,036,854,775,807 rows. Often I have dealt with very large tables heavily fragmented because of guid pkeys, when an int column with identity would have worked just fine. Nice details comparing identity to guids. UNIQUE key based on the real data in your table. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |