You can use hibernation on a desktop. The contents of RAM are saved out to disk before the PC turns off. It's then loaded back in on power up rather than a normal boot - i.e. you can continue with things where you left off in the same way as standby (saved to RAM).

Leave the pagefile alone - system managed is all you need.