Rapla 0 Report post Posted July 28, 2006 Assalamualaikum...Aku ada satu soalan....Dalam SQL Server, bila kita create Database guna Enterprise Manager....kita boleh Allocate Space untuk database tue...Automatic growth and Max size dan juga kita boleh set size untuk Log file. Lepas kita dah hasikan satu database baru, bila kita tgk properties database tu, akan ditunjukkan saiz dan Space Available. Contohnya:-Saiz Database = 4.00MBSaiz Available = 3.09MBSoalannye, Kemana perginya 0.91MB? dan bagaimana nak calculate space yg dah digunakan tue? Boleh sesiapa tolong jelaskan...Terima Kasih Quote Share this post Link to post Share on other sites
pinggan 1 Report post Posted July 28, 2006 kalau salah tolong betulkan...aku pun tak berapa arifsize file 0.91MB biasa nya akan digunakan untuk menyimpan info (file tagging) tentang file tue sendiricontoh:- location path- summary file- date access, modified dan createsize yang diambil biasanya bergantung pada bilangan tab yang terhasil bila kita right click file. macam komputer aku bila aku right clik dia ada tab (General, Summary, Netware Version)File>right click>properties Quote Share this post Link to post Share on other sites
Rapla 0 Report post Posted July 28, 2006 tapikan....aku nak tau calculation dia camana? memang 0.91MB tue digunakan oleh system table by default...tapi macamana kiraan dia? Quote Share this post Link to post Share on other sites
pinggan 1 Report post Posted July 29, 2006 sorry laa lambat replyko masuk link nie...ada detail explaination...http://www.webopedia.com/TERM/S/size_on_disk.html Quote Share this post Link to post Share on other sites
Rapla 0 Report post Posted July 31, 2006 Terima Kasih Pinggan...sat aku baca dulu.Pinggan,Ini saiz On Disk yang pakai FAT semua tue...emm ada resource lain tak? Quote Share this post Link to post Share on other sites
pinggan 1 Report post Posted August 2, 2006 OK FAT tue kira simple punya...tapi dia punya konsep sama jerkkko try tengok kat forum nie diorang ada discuss lagi detail..http://www.sql-server-performance.com/foru...?TOPIC_ID=11161 Quote Share this post Link to post Share on other sites