Wednesday

SharePoint Scheme not designed well - SQL Team

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