Tag Archives: View

70-451–MCITP–Designing a Database for Optimal Performance – Design Scalable Database Solutions

Requirements Design scalable database solutions.This objective may include but is not limited to: scale up vs. scale out, federated databases, distributed partitioned views, scalable shared databases, replication, offloading read-only query (database mirroring) My Take In this section we will very … Continue reading

Posted in SQL | Tagged , , , , , | 1 Comment

70-451 – MCITP – Designing Programming Objects – Design Views

Requirements Design views. This objective may include but is not limited to: common table expressions, partitioned views, WITH CHECK OPTION, WITH SCHEMABINDING My Take This section will show some of the options associated with views. It should be noted that … Continue reading

Posted in SQL | Tagged , , | 3 Comments