I just had an interview and couldn't answer one question which states "How many rows can a Fact table contain?" and "What is the maximum size of a fact table?"
Besides the storage size limitations, if the definition of a table requires there to be a primary key, the largest numeric key possible is NUMERIC(38, 0). It would be 17 bytes and would allow for from -10^38+1 through 10^38-1 rows.