Take the 2-minute tour ×
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. It's 100% free, no registration required.

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.

3  
Does a datatype retrieve rows? Since when? Your sentence makes no sense - are we supposed to guess now? –  TomTom Dec 4 '13 at 14:34
add comment

1 Answer 1

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.

int

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

bigint

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
add comment

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