Archive for March, 2011

Converting Thick Disk to Thin Provisioned Disk

Tuesday, March 8th, 2011

vmkfstools -i thick.vmdk -d thin thin.vmdk

Find a value appears twice in a table

Tuesday, March 8th, 2011

SELECT * FROM t1 AS t
WHERE 2 = (SELECT COUNT(*) FROM t1 WHERE t1.id = t.id);