Data type Bigint: is this considered to be Big Data?
12/13/20231 min read
Data type Bigint
In English
The maximum value of data type bigint (in SQL Server) is 2^63=9.223.372.036.854.775.807, which is 9 quintillion, 223 quadrillion, 372 trillion, 36 billion, 854 million, 775 thousand, 8 hundred and 7 :-). That number minus 1 is the maximum number of records within a datafile, which can be imported by BCP in SQL Server. It is not sure whether this amount of records is considered to be Big Data.
In Dutch
De maximale waarde van data type bigint (SQL Server) is 2^63=9.223.372.036.854.775.807, uit te spreken als: 9 triljoen (quintillion), 223 biljard (quadrillion), 372 biljoen (trillion), 36 miljard (billion), 854 miljoen (million), 775 duizend (thousand), 8 honderd (hundred) en 7 :-). Dat getal minus 1 is het maximaal aantal records van een datafile, die met BCP in SQL Server geïmporteerd kan worden.