Flylib.com
List of Tables
Previous page
Table of content
Next page
Chapter 1: Designing a Data Access Strategy
Table 1-1: Recommended Uses for Data Providers
Table 1-2: Namespaces and Objects Used to Connect to Data Sources
Chapter 2: Designing Database Queries
Table 2-1: Data Providers Available for Linked Servers
Table 2-2: Query Results When Using the
PIVOT
Operator
Table 2-3: Query Results When Using the
APPLY
Operator
Table 2-4: Query Results When Using the
ROW_NUMBER
Function
Table 2-5: Built-in Aggregate Functions
Table 2-6: Partial Query Results After Executing First SELECT Statement
Table 2-7: Query Results When Using the Query in Exercise 1
Chapter 3: Designing a Cursor and Caching Strategy
Table 3-1: Attributes of the
OutputCache
Directive
Chapter 4: Advanced Query Topics
Table 4-1: Server Management Object (SMO) Namespaces
Chapter 7: Optimizing SQL Server 2005 Performance
Table 7-1: Theoretical Execution Order - Excluding the UNION Clause
Table 7-2: Theoretical Execution Order - Including the UNION Clause
Table 7-3: Items from the Graphical Execution Plan
Test TableA
Table 7-4: Query Performance Matrix
Table 7-5: Index Size Matrix
Table 7-6: Levels of the NoIncludedColumns Index
Table 7-7: Levels of the IncludedColumns Index
Table 7-8: Levels of the
IncludedColumns
Index
Table 7-9: Subset of the sys.dm_db_index_usage_stats DMV
Chapter 8: Improving Database Application Performance
Table 8-1: Advantages and Disadvantages of Scale-Out Techniques
Table 8-2: Partition Function Catalog Views
Table 8-3: Templates Included with SQL Server Profiler
Table 8-4: Default Performance Counters for System Monitor
Table 8-5: Performance Counters Recommended by Microsoft for Performance Baseline
Table 8-6: Key Counters for Diagnosing Problems
Table 8-7: Key Dynamic Management Views for Diagnosing Problems
Appendix B: SQL Server 2005 Architecture and Internals
Table B-1: CLR Host Assembly Permissions
Previous page
Table of content
Next page
MCITP Self-Paced Training Kit Exam 70-442 .Designing and Optimizing Data Access by Using Microsoft SQL Server 2005
ISBN: 073562383X
EAN: N/A
Year: 2007
Pages: 162
BUY ON AMAZON
Java I/O
Output Streams
Server Sockets
Channels
Converting Between Byte Arrays and Strings
Serial I/O
Identifying and Managing Project Risk: Essential Tools for Failure-Proofing Your Project
Why Project Risk Management?
Identifying Project Scope Risk
Identifying Project Schedule Risk
Managing Project Risk
Conclusion
FileMaker Pro 8: The Missing Manual
What Is a Layout?
Relational Databases Explained
Advanced Relationship Techniques
Creating a Calculation Field
Import Data Sources
MySQL Clustering
Installation
Retrieving the Latest Snapshot from BitKeeper
Restoring a Backup
Security and Management
Individual Programs
Programming Microsoft ASP.NET 3.5
ASP.NET Core Server Controls
ASP.NET Security
Working with Images in ASP.NET
Hosting ASP.NET Outside IIS
Index
File System Forensic Analysis
Summary
File Name Category
Bibliography
File System Metadata Files
Bibliography
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies