Most of the problems you've probably heard about were caused by application software (eg: Norton Antivirus) that wasn't "SP2-ready." Currently, most commercial software has been upgraded and/or patched (or fixes are available from the manufacturer) to work with SP2. Check with the makers of your application software to ensure that the versions you have are SP2-compatible.