| Microsoft® SQL Server™ 2000 dramatically
reduces the time needed to bring the most powerful e-commerce, data warehousing,
and line-of-business applications to market. MICROSOFT SQL SERVER 2000
REFERENCE LIBRARY provides the ideal set of reference materials for SQL
Server-direct from Microsoft SQL Server 2000 Books Online. This well-conceived,
intelligently indexed six-volume set sensibly organizes and condenses the
vast sea of available SQL Server technical reference information. It contains
carefully selected documentation for SQL Server 2000, including expert
information, tips on how to improve performance, a comprehensive glossary
of SQL terms, and a complete statement index. This essential reference
collection includes these six volumes:
SQL SERVER 2000 ARCHITECTURE AND XML/INTERNET
SUPPORT
This volume describes the SQL Server 2000
feature set and provides a detailed analysis of the SQL Server 2000 architecture.
It explains where SQL Server fits in the Microsoft server family, describes
its administration and development tools, and explains features that simplify
data warehousing, online analytical processing (OLAP), and data mining.
You'll also learn about the support in SQL Server 2000 for Extensible Markup
Language (XML) and other Internet technologies and standards, plus how
to retrieve and write XML data, access SQL Server using HTTP, use XPath
queries, use SQL Server with Internet Information Services, and more. This
volume also contains a comprehensive glossary of SQL Server terms.
DATABASE CREATION, WAREHOUSING, AND OPTIMIZATION
This volume focuses on how to create and
maintain databases, create data warehouses, and optimize SQL Server 2000.
It gives you definitive documentation about SQL Server 2000 databases,
tables, indexes, views, stored procedures, triggers, user-defined functions,
and full-text indexes. It also details the parts of a data warehouse and
documents how to create and maintain one. It then describes how to enhance
database performance through efficient database and application design,
query tuning, and optimizing tool, utility, and server performance.
ANALYSIS SERVICES
This volume provides an overview and details
about SQL Server 2000 Analysis Services (formerly known as OLAP), including
what's new in Analysis Services in SQL Server 2000 and how to install those
services. It describes the Analysis Services architecture in SQL Server
2000, provides details on data warehousing, data mining and OLAP, and gives
you comprehensive information on how to administer Analysis Services (complete
with an administrator's reference), multidimensional expressions (MDX),
and related decision tools.
REPLICATION AND ENGLISH QUERY
This volume is the essential one-stop
resource on replication services in SQL Server 2000. It includes everything
you need to know to plan for and implement replication, and it offers complete
information about replication types, tools, and options, data considerations,
heterogeneous data sources, security, administering and monitoring replication,
enhancing replication performance, and backing up and restoring replicated
databases. This volume also discusses the revolutionary English-language
query services in SQL Server 2000. It provides an English Query overview
and fundamentals, discusses how to develop and deploy English Query applications,
describes how to use analysis services with English Query, and shows how
to perform common English Query tasks. It also includes an English Query
object model reference.
T-SQL LANGUAGE REFERENCE
Transact SQL (T-SQL) is central to Microsoft
SQL Server, since all applications that communicate with SQL server, regardless
of their interface, do so by sending T-SQL statements to the server. This
volume provides essential programmatic information about the T-SQL language.
It includes a T-SQL overview, a complete T-SQL reference, and extensive
details about what's new and enhanced in the language in SQL Server 2000.
It also gives you comprehensive information about T-SQL data types, operators,
reserved keywords, globals, functions, and DBCC statements. A complete
T-SQL statement index is also included, along with two sample databases.
T-SQL STORED PROCEDURES AND TABLES REFERENCE
You can perform many routine administrative
and information activities in Microsoft SQL Server by using stored procedures
that manage Active Directory™ services, data dictionary functions, core
maintenance tasks, replication, full-text searching, log shipping, security,
system maintenance, Web Assistant tasks, XML text management, the SQL Profiler
and SQL Server Agent, and more. This volume gives you vital programmatic
information about how to use these new and enhanced stored procedures in
SQL Server 2000. |
