MCITP Self-Paced Training Kit Exam 70-442 .Designing and Optimizing Data Access by Using Microsoft SQL Server 2005

2017-07-07 02:10:07

Chapter 1: Designing a Data Access Strategy

Figure 1-1: Using SQL Server Configuration Manager to configure network protocols for the server
Figure 1-2: Using SQL Server Configuration Manager to configure network protocols for the client
Figure 1-3: Drivers tab in the ODBC Data Source Administrator utility
Figure 1-4: References dialog box used to set a reference to the latest MDAC library
Figure 1-5: Login - New dialog box used to create a user login in SQL Server Management Studio
Figure 1-6: Add Web Reference dialog box for an ASP.NET project created with Visual Studio 2005
Figure 1-7: Add New Linked Server dialog box in SQL Server Management Studio
Figure 1-8: Form1 as it displays a list of all engineering employees from the AdventureWorks database

Figure 2-1: Supported data providers listed below the Providers node in Object Explorer
Figure 2-2: New Linked Server dialog box used to configure a linked server that points to an Access 2003 database
Figure 2-3: Portion of the results window that displays the query results, where the first record contains an empty string in the color column
Figure 2-4: Execution plan for a query executed in SQL Server Management Studio
Figure 2-5: Execution plan for a poorly performing query executed in SQL Server Management Studio
Figure 2-6: XML schemas available with the AdventureWorks database

Figure 3-1: Expanding the Service Broker node and looking at the available queues for the AdventureWorks database
Figure 3-2: Execution time is displayed in the status bar of the new query window
Figure 3-3: Configuring the SQL Server Profiler trace to monitor specific events
Figure 3-4: Trace results for a trace performed while executing the spGetPriorProduct stored procedure.

Figure 4-1: Add Reference to the Microsoft.SqlServer.Smo assembly, which is used in an SMO application
Figure 4-2: Creating a new database
Figure 4-3: Files page for the properties of the newly created test database
Figure 4-4: Connection Manager dialog box used when creating a new data source for an Analysis Services project
Figure 4-5: Select Table and Views dialog box, used when creating a new data source view for an Analysis Services project

Figure 7-1: An execution plan from SQL Server Management Studio showing an Index Scan operation
Figure 7-2: An execution plan from SQL Server Management Studio showing an Index Seek operation
Figure 7-3: An execution plan from SQL Server Management Studio
Figure 7-4: An execution plan from SQL Server Management Studio
Figure 7-5: Execution plans for Queries 1–3 in SQL Server Management Studio
Figure 7-6: An execution plan from SQL Server Management Studio of the insert statement used in this test
Figure 7-7: An execution plan from SQL Server Management Studio of the insert statement used in this test
Figure 7-8: An execution plan from SQL Server Management Studio of the insert statement used in this test
Figure 7-9: An execution plan of the previous select statement from SQL Server Management Studio
Figure 7-10: An execution plan of the select using the computed column in the WHERE clause
Figure 7-11: An execution plan of Query #1 in SQL Server Management Studio
Figure 7-12: An execution plan of Query #2 in SQL Server Management Studio
Figure 7-13: An execution plan of the query in SQL Server Management Studio
Figure 7-14: An execution plan of the query in SQL Server Management Studio
Figure 7-15: An execution plan of the query in SQL Server Management Studio

Figure 8-1: Storage page within the properties for the ProductID index
Figure 8-2: The Check Constraints dialog box used to add a new constraint to the Person.Contact table
Figure 8-3: Enable CLR Integration using the SQL Server Surface Area Configuration tool
Figure 8-4: The Filegroups page as displayed in the Properties dialog box for the AdventureWorks database
Figure 8-5: The Storage page for the AK_Product_ProductNumber index properties
Figure 8-6: General trace properties for a new trace created with SQL Server Profiler
Figure 8-7: Events Selection tab for a new trace that is based on the blank template
Figure 8-8: Events Selection tab for a new trace that is based on the blank template
Figure 8-9: Default counters measured by local instance of System Monitor
Figure 8-10: Add Counters dialog box used to add performance counters to a System Monitor graph

Figure B-1: SQL Server internal components covered by this appendix
Figure B-2: The hierarchical relationship between SQLOS nodes, schedulers, and tasks
Figure B-3: Displaying the SQLOS memory node configuration and allocations
Figure B-4: Configuring the processor affinity using the Microsoft SQL Server 2005 Management Studio Server Properties dialog box
Figure B-5: Configuring SQL Server 2005 to listen on an additional TCP port
Figure B-6: Configuring SQL Server 2005 to utilize IP Port affinity
Figure B-7: Using SQL Server 2005 Dynamic Management Views to query SQLOS wait types
Figure B-8: Using SQLOS to display all currently executing statements and their resource utilization
Figure B-9: Querying SQLOS to determine the current system workload distribution
Figure B-10: Querying SQLOS to determine the degree of parallelism of currently executing queries
Figure B-11: Determining the objects that have data currently stored in buffer cache
Figure B-12: The SQL Server 2005 query engine components
Figure B-13: The SQL Server 2005 Query Execution Plan Architecture
Figure B-14: The SQL Server 2005 NonClustered Index Structure
Figure B-15: The SQL Server 2005 Clustered Index Structure
Figure B-16: The SQL Server 2005 database encryption hierarchy
Figure B-17: Using the SQL Server Configuration Manager
Figure B-18: Using the SQL Server Configuration Manager to install a certificate