Monthly Archives: February 2011

70-451–MCITP–Designing Queries for Performance–Optimize and Tune Queries

Requirements Optimize and tune queries. This objective may include but is not limited to: optimizer hints, common table expressions (CTEs), search conditions, temporary storage, GROUP BY [GROUPING SETS|CUBE|ROLLUP] My Take The task of optimizing and tuning queries is something which … Continue reading

Posted in SQL | Tagged , , | 4 Comments

70-451–MCITP–Designing an XML Strategy–Design a Strategy to Transform XML into Relational Data

Requirements Design a strategy to transform XML into relational data.This objective may include but is not limited to: .nodes, .value, .query, XQuery and XPath My Take In this section we will investigate how we query the XML data to retrieve … Continue reading

Posted in SQL | Tagged , , | 1 Comment

70-451–MCITP–Design an XML Strategy–Design a Query Strategy by using FOR XML

Requirements Design a query strategy by using FOR XML.This objective may include but is not limited to: views, FOR XML PATH and EXPLICIT, FOR XML…TYPE My Take This section appears to be concerned with how it is that we will … Continue reading

Posted in SQL | Tagged , , | 3 Comments

70-451–MCITP–Design an XML Strategy–Design a Strategy to Query and Modify XML Data

Requirements Design a strategy to query and modify XML data.This objective may include but is not limited to: when to use appropriate XPath and XQuery expressions, .query vs. .value, XML indexes for performance, typed vs. untyped, .exist, .modify My Take … Continue reading

Posted in SQL | Tagged , , | 2 Comments

70-451–MCITP–Designing an XML Strategy – Design XML Storage

Requirements Design XML storage.This objective may include but is not limited to: determining when to use XML for storage, untyped vs. typed (XML schema collection) My Take It seems to me that this section wants us to look into why … Continue reading

Posted in SQL | Tagged , , | 1 Comment