Vista's high memory usage is a feature, not a bug. The OS pre-loads it to maximize performance. When a 3rd party application request memory Vista automatically allocates it.
You shouldn't have to set the core affinity either.
I dual boot XP & Vista and SC4 runs just as good on Vista, in fact I uninstalled it from my XP partition