Windows actually has very good memory management - most 'tweaks' actually end up reducing performance.
There is a very good reason why Windows uses the pagefile, even though it has memory available - it unloads rarely used parts of the OS, into the swap file to free up RAM for applications, more frequently used parts of the OS, and the disk cache. Disabling the page file will actually degrade performance, because unnecessary data is held in RAM reducing available memory for disk caches.
Some programs require a page file as well - this is due to the way in which Windows shares memory between applications - Each application runs in a totally seperate memory space - however, applications can apply for 'shared memory' to which they all have direct access - To circumvent the rules that prevent applications for interfering with each other, the shared memory has to be backed by a file on a drive - this is almost always the page file.
There is also relatively little need for a RAMdisk, because the dynamic caches offered by modern OSs, offer most of the performance benefit with an altogether more flexible package.