Quiz 70-451, PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008
You need to design a method for storing large XML-formatted data
You need to rewrite the stored procedure to use a single statement to load the data
What should you recommend?
You need to retrieve all levels by using a single Transact-SQL query
You need to minimize the amount page I/O that is generated when the query runs
You need to ensure that the query retrieves data in minimum possible time
You need to ascertain that the indexes are used optimally
You need to identify the most likely cause for the problems by analyzing the execution plan
You need to ensure that the query executes as quickly as possible