Thursday, March 22, 2012

hey,
select * from sysfiles:
mdf size: 1000000
can anyone tell me why i must multiply by 8 and divide by
1024 to get the size of the database in MB? i know its a
dumb question bu.. from BOL,
size int Size of the file (in 8-KB pages).
so you can get the transfer rules
"'" <anonymous@.discussions.microsoft.com> wrote in message
news:863501c3e988$aa956f50$a001280a@.phx.gbl...
quote:

> hey,
> select * from sysfiles:
> mdf size: 1000000
> can anyone tell me why i must multiply by 8 and divide by
> 1024 to get the size of the database in MB? i know its a
> dumb question bu..
sql

No comments:

Post a Comment