SQL Server database query Delete and Insert question

Question

0.00/5 (No votes)

See more:

, +

I have an SQL Database which has a column with the primary key "id" with data type BigInt

When I use the query to delete and insert things. it continues to increment the id number.

I am worried about if I insert and delete things 1000s of times, that it would eventually have the id number go off Bigint boundaries. Is this possible?

If it is possible I want to know if I could delete an item each time, it would move all the data/id number ahead of it to fill in the missing spot. Kind of similar to what you have to do to an array.

Posted 7-Jul-11 13:42pm

Member 8015046

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Espen Harlinn · Accepted Answer · 2011-07-07T13:46:00

Solution 1

"I am worried about if I insert and delete things 1000s of times, that it would eventually have the id number go off Bigint boundaries. Is this possible?"

It certainly is - it'll take a while though - I'll be quite surprised if any of us is still around :)

Best regards
Espen Harlinn

Posted 7-Jul-11 13:46pm

Espen Harlinn

fjdiewornncalwe · Accepted Answer · 2011-07-07T14:35:00

Solution 2

A bigint is 8 bytes in size which means you will have a max value of 9,223,372,036,854,775,807. I think you'll be ok.

Posted 7-Jul-11 14:35pm

fjdiewornncalwe

Wonde Tadesse · Accepted Answer · 2011-07-07T15:58:00

Solution 3

Bigint size is -2^63 through 2^63-1. You are quite far away to reach here. There is no worry about it.

Posted 7-Jul-11 15:58pm

Wonde Tadesse

Youzelin · Accepted Answer · 2011-07-07T16:15:00

Solution 4

To tell the truth, what you concern is not necessary to be thought. As Marcus Kramer puts it, the boundary is so large that you can ignore it.

But by the way, I want to ask you why do you worry about that ? Furthermore, what things do you want to do ?

Posted 7-Jul-11 16:15pm

Youzelin

Comments

Member 8015046 8-Jul-11 11:03am

Well I know multiple machines use this server, each Posting of a message is id. And each of these machines does 100 thousands times. So I don't know how many times it would do it. I just want to make it fail proof =P