March 23, 2005 at 9:52 am
Hi,
MSSQL 2000
Why does the column "size" in the result set from sp_helpfile NOT equal the file size returened using other tools such as MS Win Explorer or the DOS DIR command?
Many thanks. Jeff
March 23, 2005 at 10:03 am
Is the volume compressed?
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
March 23, 2005 at 11:39 am
no
Many thanks. Jeff
March 23, 2005 at 11:41 am
How far off is it? Do you have any specific examples?
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
March 23, 2005 at 11:45 am
Hi, yes ...
For example:
looking at the Temp db (tempdb.mdf):
* Dos Dir Cmd = 1,106,182,144
* MS Win Explorer = 1080256 kb
* exec sp_helpfile = 982016
Many thanks. Jeff
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply