tailieunhanh - Designing SQL Server 2000 Database P2

With this exciting list of features in mind, we begin this book by reviewing the new and enhanced features of SQL Server 2000 and the migration considerations for those of you who are already using previous versions of SQL Server. | xxx Introduction and reliability position SQL Server 2000 as the first release to compete in the demanding markets of terabyte-size solutions and 24 x 7 availability. With this exciting list of features in mind we begin this book by reviewing the new and enhanced features of SQL Server 2000 and the migration considerations for those of you who are already using previous versions of SQL Server. The benefits and simplicity of migrating make this upgrade a practical necessity if your organization aims to compete in today s economy. A review of Microsoft s Distributed Internet Architecture DNA model and the pending evolution toward .NET will help you understand how SQL Server 2000 fits into Microsoft s vision of complete solutions design. From there we review the installation options and procedures for SQL Server 2000. New features such as multiple-instance support allow you to run numerous distinct copies of SQL Server on a single server. This capability is a boon to the growing application service provider market allowing you to partition large expensive servers among multiple customers or applications each with its own unique configuration. Several versions of SQL Server are available to meet both application requirements and budgets. After we get SQL Server 2000 up and running each chapter examines the capabilities available in SQL Server. From creating databases to setting up replication to using XML with SQL Server we work through practical examples so you can begin using each of these features in your application. Using both graphical wizards and Transact-SQL statements you will learn how simple and powerful working with SQL Server can be. You will quickly discover that SQL Server 2000 is more than just a database server it s a solution platform. Understanding SQL Server s capabilities will become critical to designing and delivering your applications in an increasingly demanding market. Whether you are a veteran SQL Server user or you need to get SQL Server up