Hi,
I have a discussion forum as a part of my website. In the database structure i have declared postid as identity of datatype decimal. Now i want to delete the meaningless posts submitted by users. Now there are two options whether to delete a post directly without resetiing identity column which will make gap between postid(like 151,154,155,156) when new post is submitted. Other option is to delete the post and reset the identity but that will affect the sorting order of postid (like 151,154,152,153)
So which is the better option whether to reset the identity column on delete or not ?
Thanks
...
Go to the complete details ...