BPCUK 2011: Best Practices – IT Pro

SQL Server Maintenance – for improving performance, use defragmentation. Health Analyzer can tell you when it’s necessary – never shrink, only if you know for sure that the DB never ever ever grows again – (officially) run checkDD once a week (no one does it) – if SQL is on the same machine as SP, … Read more