Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How many rows does datatype int and big int retrieve in their table when you work with fact table in SQL server?

share|improve this question

closed as unclear what you're asking by Phil, billinkc, swasheck, Kin, Mark Storey-Smith Dec 4 '13 at 16:13

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question.If this question can be reworded to fit the rules in the help center, please edit the question.

Not sure I understand specifically what your question is or what exactly you're trying to do, but take a look at this BOL reference on int, bigint, smallint, and tinyint.


Size: 4 bytes
Min: -2,147,483,648
Max: 2,147,483,647


Size: 8 bytes
Min: -9,223,372,036,854,775,808
Max: 9,223,372,036,854,775,807

If you're asking about what are the upper limits of a sequential number (for instance, an IDENTITY column) then the max rows will be the Max values shown above, provided an initial value of 1.

share|improve this answer
For future readers, note that IDENTITY can also be seeded such that the negative numbers are used as well. – Jon Seigel Dec 4 '13 at 16:55

Not the answer you're looking for? Browse other questions tagged or ask your own question.