SQL Server DBA

Database design review, data types, partitioning, compression, and filegroup strategy

Question

BIGINT vs. INT: what differs, and when should each be used?

Answer

INT stores 32-bit signed whole numbers; BIGINT stores 64-bit signed whole numbers. Use INT when its range is demonstrably sufficient; use BIGINT for high-growth keys or aggregates. Changing a clustered key later is expensive.

This is 5 of 25 free samples for SQL Server DBA.

More SQL Server DBA topic samples