SQL Team recognizes that the SharePoint schema is not designed well
Commonly Perceived Gaps
1. SharePoint tables are too wide, wraps rows
2. SharePoint manages its own (NVP) indexes
3. SharePoint adds force-order, query hints
4. Missing indexes for common operations
5. Excessive use of Dynamic queries
6. No SQL Referential Integrity OR key constraints
7. Missing integration of Back-up/Restore