How many rows does datatype int and big int retrieve in their table when you work with fact table in SQL server?
closed as unclear what you're asking by tblPhil, 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
Size: 8 bytes
If you're asking about what are the upper limits of a sequential number (for instance, an