Friday, February 12, 2010

Top 10 Mistakes on SQL SERVER

10. Unknown Scalability Requirements

9. Improperly Normalized Tables

8. Improper Indexing

7. No Baseline or Benchmarks

6. Disks — Thinking about Space but Not I/O

5. Lack of Error Notification

4. Poor or Nonexistent Backup Strategy

3. Lack of Query Tuning and Optimization

2. Ignorance of Internals

1. Overuse of Cursors


No comments:

Post a Comment