SQL Server 2000 White Papers

1. ADO.NET Primer
2. Analysis Services: Choosing Dimension Types in SQL Server 2000 Analysis Services
3. Analysis Services: DISTINCT COUNT, Basket Analysis, and Solving the Multiple Selection of Members Problem
4. Analysis Services: Optimizing Cube Performance Using Microsoft SQL Server 2000 Analysis Services
5. Analysis Services: Performance Implications of the Architecture
6. Analysis Services: Semiadditive Measures and Inventory Snapshots
7. Arabic Language Support in Microsoft SQL Server 2000
8. Best Practices for Business Intelligence Using the Microsoft Data Warehousing Framework
9. Best Practices for Using DTS for Business Intelligence Solutions
10. Bitmaps in Microsoft SQL Server 2000
11. Building Search Applications for the Web Using Microsoft SQL Server 2000 Full-Text Search
12. Code Access Security in SQL Server 2000 Reporting Services
13. Connection Pooling with SQL Server 2000 Analysis Services
14. Creating Merge Replication Custom Conflict Resolvers Using Visual Basic
15. Data Transformation Services (DTS) in Microsoft SQL Server 2000
16. Data Warehouse Design Considerations
17. Database Architecture: The Storage Engine
18. Deployment Considerations for the Voicemail .NET Alerts Quick Start Kit on Notification Services
19. Developing Effective Decision Support Objects (DSO) Solutions with Microsoft SQL Server 2000 Analysis Services
20. Diagnosing and Troubleshooting Slow Partitioned Merge Processes
21. DTS Programming Techniques Used in Microsoft SQL Server Accelerator for Business Intelligence
22. Embedding MSDE 2000 Setup into the Setup of Custom Applications
23. Evolution of the SQL Server Programming Model from ADO to ADO.NET 2.0
24. Identifying Common Administrative Issues for Microsoft SQL Server 2000
25. Implementing Referential Integrity and Cascading Actions
26. Implementing the XML for Analysis Provider for SQL Server 2000 Analysis Services
27. Improved Web Connectivity in Microsoft SQL Server 2000 Analysis Services
28. Improving Performance with SQL Server 2000 Indexed Views
29. Index Tuning Wizard for Microsoft SQL Server 2000
30. Inside the SQLXML Virtual Directory Structure
31. Integrating Analysis Services with Reporting Services
32. International Features in Microsoft SQL Server 2000
33. Microsoft Reporting Services in Action: Extending Microsoft SQL Server 2000 Reporting Services with Custom Code
34. Microsoft SQL Server 2000 as a Dimensionally Friendly System
35. Microsoft SQL Server 2000 Distributed Queries: OLE DB Connectivity
36. Microsoft SQL Server 2000 Scalability Project--Server Consolidation
37. Middle Tier Application Data Caching with SQL Server 2000
38. Moving Your Access 2002 Database to SQL Server
39. Notification Services Capacity Planning and Performance Tuning
40. Notification Services Quick Start Guide for Sample Installation
41. OLAP Distinct Counts and Performance Analysis
42. Optimizing SQLXML Performance
43. Optimizing Cell Writeback in Microsoft SQL Server 2000 Analysis Services
44. Preserving Client-Server Data Integrity with Unicode and Microsoft SQL Server 2000
45. Query Recompilation in SQL Server 2000
46. Registry Entries for Microsoft SQL Server 2000 Analysis Services
47. SmallLibrary Sample: Incorporating Notification Services
48. SQLXML Managed Classes
49. Statistics Used by the Query Optimizer in Microsoft SQL Server 2000
50. The Reality of Real-time OLAP
51. Transactional Replication Performance Tuning and Optimization
52. Tutorial: Creating an Ad Hoc Report Application with Reporting Services
53. Using an ADO.NET DataSet as a Reporting Services Data Source
54. Using Forms Authentication in Reporting Services
55. Using Partitions in a Microsoft SQL Server 2000 Data Warehouse
56. Using Secure Sockets Layer (SSL) for SQL Server 2000 Reporting Services
57. Using SQL Server 2000 Technologies to Deliver Data
58. XML to SQL: Using SQLXML Bulkload in .NET Framework
59. Breaking Down Scalability Barriers with SQL Server 2000 Enterprise Edition (64-bit)
60. Comparing Business Intelligence Platforms
61. A Comparison of Data Warehousing Strategies and Platforms
62. Database Manageability Tools: A Comparison of SQL Server 2000 and DB2 Version 8
63. Forrester Report: Microsoft Addresses Enterprise ETL
64. SQL Server Scalability Project
65. Migrating Siebel CRM to SQL Server 2000 on Microsoft Windows Yields Significant Benefits
66. The Advantages of Running SAP Applications on SQL Server 2000 (64-bit)
67. Advantages of a 64-bit Environment: SQL Server 2000 (64-bit)
68. SQL Server 2000 Pricing and Licensing
69. Understanding Database Pricing
70. Using Microsoft SQL Server Analysis Services with IBM Databases
71. Using Microsoft SQL Server Data Transformation Services with IBM Databases
72. SQL Server 2000 I/O Basics
• Learn the I/O requirements for Microsoft SQL Server database file operations. This will help you increase system performance and avoid I/O environment errors.

Because new devices and storage solutions continue to appear in the marketplace, the environments in which Microsoft® SQL Server™ runs have become extremely diverse. To ensure data integrity for our customers who are running SQL Server, it is important that I/O environments provide appropriate functionality.

The purpose of this paper is to explain the Input/Output (I/O) requirements for SQL Server database file operations so that vendors and customers can evaluate and adjust their environments to meet the needs of SQL Server.

73. SQL Server I/O Basics, Chapter 2
• As the administrator of a SQL Server 2005 installation, you will find that visibility into the SQL Server I/O subsystem has been significantly increased. A primary focus of the SQL Server 2005 I/O design was overall stability of performance and data integrity related to the outside influences of the I/O subsystem/path. The new and extended features provide both more visibility and more capabilities.

This white paper introduces new terms, discusses maintenance and configuration issues, new and improved error messages, and I/O enhancements. After reading this document you will better understand SQL Server I/O needs and capabilities in SQL Server 2000 Service Pack 4 and SQL Server 2005.