SQL Server 2000

SQL Server 2005
SQL Server 2005 Express Edition
SQL Server 2000
Microsoft SQL Server 2000 (64-bit)
SQL Server 7.0
SQL Server (General)
English Query
Reporting Services
SQL Server Notification Services
SQLXML
SQL Server 2000 Windows CE Edition
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnanchor/html/sqlserver2000.asp

SDK Documentation
Getting Started
What's New
Installing SQL Server
SQL Server Architecture
Administering SQL Server
Creating and Maintaining Databases
Creating and Using Data Warehouses
Aclearcase/" target="_blank" >ccessing and Changing Relational Data
XML and Internet Support
Transact-SQL Reference
Optimizing Database Performance
Replication
Data Transformation Services
Analysis Services
English Query
Meta Data Services
Building SQL Server Applications
Using the SQL Server Tools
User Interface Reference
Troubleshooting
Glossary
How To

Technical Articles

ADO.NET Primer
Advanced T-SQL: Automate the Generation of Stored Procedures for Your Database
Analysis Services: Choosing Dimension Types in SQL Server 2000 Analysis Services
Analysis Services: DISTINCT COUNT, Basket Analysis, and Solving the Multiple Selection of Members Problem
Analysis Services: Optimizing Cube Performance Using Microsoft SQL Server 2000 Analysis Services
Analysis Services: Performance Implications of the Architecture
Analysis Services: Semiadditive Measures and Inventory Snapshots
Arabic Language Support in Microsoft SQL Server 2000
Best Practices for Business Intelligence Using the Microsoft Data Warehousing Framework
Best Practices for Using DTS for Business Intelligence Solutions
Bitmaps in Microsoft SQL Server 2000
BizTalk and XML: Add E-Commerce to Your App with XML and SQL Server 2000
Building Search Applications for the Web Using Microsoft SQL Server 2000 Full-Text Search
Code Access Security in SQL Server 2000 Reporting Services
Connection Pooling with SQL Server 2000 Analysis Services
Creating Merge Replication Custom Conflict Resolvers Using Visual Basic
Data Points: Creating Audit Tables, Invoking COM Objects, and More
Data Points: Exception-handling Techniques
Data Points: Exploring SQL Server Triggers: Part 2
Data Points: Exploring SQL Server Triggers
Data Points: Five Ways to Rev up Your SQL Performance
Data Points: SQL Server User-defined Functions
Data Transformation Services (DTS) in Microsoft SQL Server 2000
Data Warehouse Design Considerations
Database Architecture: The Storage Engine
Deployment Considerations for the Voicemail .NET Alerts Quick Start Kit on Notification Services
Developing Effective Decision Support Objects (DSO) Solutions with Microsoft SQL Server 2000 Analysis Services
Diagnosing and Troubleshooting Slow Partitioned Merge Processes
DTS Programming Techniques Used in Microsoft SQL Server Accelerator for Business Intelligence
Embedding MSDE 2000 Setup into the Setup of Custom Applications
Evolution of the SQL Server Programming Model from ADO to ADO.NET 2.0
Identifying Common Administrative Issues for Microsoft SQL Server 2000
Implementing Referential Integrity and Cascading Actions
Implementing the XML for Analysis Provider for SQL Server 2000 Analysis Services
Improved Web Connectivity in Microsoft SQL Server 2000 Analysis Services
Improving Performance with SQL Server 2000 Indexed Views
Index Tuning Wizard for Microsoft SQL Server 2000
Inside the SQLXML Virtual Directory Structure
Integrating Analysis Services with Reporting Services
International Features in Microsoft SQL Server 2000
Microsoft Reporting Services in Action: Extending Microsoft SQL Server 2000 Reporting Services with Custom Code
Microsoft SQL Server 2000 as a Dimensionally Friendly System
Microsoft SQL Server 2000 Distributed Queries: OLE DB Connectivity
Microsoft SQL Server 2000 Scalability Project--Server Consolidation
Middle Tier Application Data Caching with SQL Server 2000
Moving Your Access 2002 Database to SQL Server
Notification Services Capacity Planning and Performance Tuning
Notification Services Quick Start Guide for Sample Installation
OLAP: Build an OLAP Reporting App in ASP.NET Using SQL Server 2000 Analysis Services and Office XP
OLAP Distinct Counts and Performance Analysis
Optimizing SQLXML Performance
Optimizing Cell Writeback in Microsoft SQL Server 2000 Analysis Services
Preserving Client-Server Data Integrity with Unicode and Microsoft SQL Server 2000
Query Recompilation in SQL Server 2000
Registry Entries for Microsoft SQL Server 2000 Analysis Services
Reporting: Deliver User-Friendly Reports from Your Application with SQL Server Reporting Services
Scripting SQL: VBScript Interfaces in SQL Server 2000 Let You Transform Data and Provide Reports to Your Users
SmallLibrary Sample: Incorporating Notification Services
SQL and XML: Use XML to Invoke and Return Stored Procedures Over the Web
SQL/MTS: Automating the Creation of COM+ Components for a Database Schema
SQL Server 2000: New Features Provide Unmatched Ease of Use and Scalability to Admins and Users
SQL Server 2000: New XML Features Streamline Web-centric App Development
SQL Server 2000 and XML: Developing XML-Enabled Data Solutions for the Web
Display Your Data Your Way with Custom Renderers for Reporting Services
SQLXML Managed Classes
SQLXML 3.0: Build Data-Driven Web Services with Updated XML Support for SQL Server 2000
Statistics Used by the Query Optimizer in Microsoft SQL Server 2000
The Reality of Real-time OLAP
Transactional Replication Performance Tuning and Optimization
Tutorial: Creating an Ad Hoc Report Application with Reporting Services
Updating Data in Linked Servers, Information Schema Views, and More
Using an ADO.NET DataSet as a Reporting Services Data Source
Using Forms Authentication in Reporting Services
Using Partitions in a Microsoft SQL Server 2000 Data Warehouse
Using Secure Sockets Layer (SSL) for SQL Server 2000 Reporting Services
Using SQL Server 2000 Technologies to Deliver Data
XML to SQL: Using SQLXML Bulkload in .NET Framework


Columns SQL Server for Developers

Detecting and Resolving Stalled and Stuck I/O Issues in SQL Server 2000 SP 4
The Perils of Fiber Mode
Internal SQL Server Diagnostics Tools, Part 1: PSSDiag
Writing Secure Transact-SQL
Writing Language-Portable Transact-SQL
SQL Server Connection Basics
Inside the SQL Server 2000 User Mode Scheduler
Inside SQL Server's Memory Management Facilities


Online Books

Windows Server System Online Books for SQL Server 2000
Created in partnership with enterprise customers, Microsoft Consulting Services, and Windows Server System product teams, the Windows Server System
Online Books for SQL Server 2000 offer practical guidance, informed insight that helps you make intelligent decisions, and relevant code examples that you can
use as a starting point for creating your own solutions. These books are up to date and delivered throughout the life cycle of the product, not just at release time,
providing you with a constant source of valuable information.

* Notification Services 2.0 Events MSDN (April 30, Online Book)
Notification Services 2.0 Events is a reference guide to all the events that can be logged to the MicrosoftR Windows Application log
by Microsoft SQL Server? Notification Services 2.0. It also provides instructions for viewing events via the Windows Event Viewer and for configuring
the types of events to be logged. This information supplements the documentation included with Notification Services 2.0.
* Using Microsoft Office XP as a BI Client MSDN (March 13, Online Book)
Using Microsoft Office XP as a BI Client shows you how to effectively use various MicrosoftR Office applications and
technologies—Microsoft Excel PivotTableR and PivotChartR reports, Microsoft Office Web Components, Microsoft Data Analyzer,
Microsoft MapPointR, and Microsoft Smart Tags—as business intelligence (BI) client solutions. Based on the BI client dilemma faced
by a real-world company, this book: demonstrates how Office XP applications and technologies interact with the online analytical processing (OLAP)
cubes stored in Microsoft SQL Server? 2000 Analysis Services; discusses how to use Office XP applications to solve specific BI client needs;
and provides comprehensive instructions on working with Office XP applications as BI clients.
* Preparing and Mining Data with Microsoft SQL Server 2000 and Analysis Services MSDN (September 16, Online Book)
Demonstrates how to apply data mining to a real-world situation using Microsoft SQL Server 2000, Microsoft SQL Server 2000 Analysis Services,
and Microsoft Visual Basic 6.0. This book takes a real-world dataset and shows you how to: clean and prepare it for data mining; explore the data
within the dataset and choose the appropriate columns for a data mining model; create data mining models from the cleaned data; and compare the
data mining models to choose the one that best solves a given problem.



http://216.239.57.106/search?hl=EN&q=tempdb&btnG=Google+Search
http://www.mssqlcity.com/TestExams.htm

原文转自：http://www.ltesting.net