Friday, February 24, 2012

64 bit database

Does INTEGER type take 8 bytes (64 bits) or 4 bytes (32 bits) of the
disk space?
MHSmallint = 2 bytes
Integer = 4 bytes
Bigint = 8 bytes
--
Ekrem Önsoy
"Marius Horak" <nobody@.eu.con> wrote in message
news:OBgwZ0e9HHA.3916@.TK2MSFTNGP02.phx.gbl...
> Does INTEGER type take 8 bytes (64 bits) or 4 bytes (32 bits) of the
> disk space?
> MH|||... and it is the same for 32 and 64 bit. In fact, the database format is exactly the same across
32/64 bit.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
news:095B7B19-6006-4BFD-A0A3-D0576725BA66@.microsoft.com...
> Smallint = 2 bytes
> Integer = 4 bytes
> Bigint = 8 bytes
> --
> Ekrem Önsoy
>
> "Marius Horak" <nobody@.eu.con> wrote in message news:OBgwZ0e9HHA.3916@.TK2MSFTNGP02.phx.gbl...
>> Does INTEGER type take 8 bytes (64 bits) or 4 bytes (32 bits) of the
>> disk space?
>> MH
>

No comments:

Post a Comment