Overall, you should notice any overall improvement with the system. The potential errors say with Adobe, will complain that there is insufficent paging file. Windows shouldn't have any problems itself. Nor should games.
1. Windows Always Sets a Page File, regardless of if its set to none. But it is very small.
2. Some programs (ie. Adobe PhotoShop) requires that there is a paging file and Windows needs it to. For what exactly, I cant remember.