Popular Posts
Join related table and count rows or sum sql server 2005 count rows: SELECT * FROM Table1 LEFT JOIN     (SELECT Level1ID, COUNT(Level2ID) AS Total FROM Table2 GROUP BY Level1ID) AS... Remove file not in list ADD ... THEN ... UNTIL ... data: begin of SERIES, N1 type I value 10, N2 type I value 20, N3 type I value 30, N4 type I value 40, ...
Stats
Compacting VirtualBox Disk Images - Linux Guests
  1. Start the Linux virtual machine;
  2. Clean the free space on the disk of the Linux virtual machine; 
    dd if=/dev/zero of=zerofillfile bs=1M
    • if= specifies the input file;
    • /dev/zero indicates a bit-stream of zeros
    • of= specifies the output file
    • zerofillfile name of the file containing the bit-stream of zeros
    • bs= indicates the block size
    • 1M indicates that the block size will be 1 megabyte
    rm zerofillfile
  3. Shutdown the Linux virtual machine;
  4. Use the VirtualBox VBoxManage utility to compact the Linux guest image.

Ref: Compacting VirtualBox Disk Images - Linux Guests