Microsoft SQL Server™ 2000
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Home > Computing and Information Technology > Computer programming / software engineering > Database programming > Microsoft SQL Server™ 2000: A Guide to Enhancements and New Features
Microsoft SQL Server™ 2000: A Guide to Enhancements and New Features

Microsoft SQL Server™ 2000: A Guide to Enhancements and New Features


     0     
5
4
3
2
1



Out of Stock


Notify me when this book is in stock
X
About the Book

Microsoft's SQL Server 2000 promises performance, scalability, and speed. Microsoft SQL Server 2000: A Guide to Enhancements and New Features shows database administrators and developers how to deliver on these promises. This book illustrates all the significant enhancements and additions in SQL Server 2000 and shows how they can be used most effectively. Readers learn by example how to use security features, replication, backup procedures, and data warehousing and optimization techniques. Beginning with an overview of SQL Server 2000, this book discusses online transaction processing (OLTP) and online analytical processing (OLAP), features a tour of different SQL Server releases, and offers a guide to installation. The author describes and demonstrates the changes since SQL Server 7.0, thoroughly exploring SQL Server 2000's capacity as a Web-enabled database server. Readers are then immersed in advanced database administration topics such as performance optimization and debugging techniques. Microsoft SQL Server 2000 also serves as a resource for those new to SQL Server, providing a basic introduction and details about how to make a conversion work, as well as a feature-by-feature comparison to Oracle 9i. Database administrators will find a collection of clearly explained scripts and utilities to simplify day-to-day tasks. This book concludes with a discussion of how SQL Server fits into the .NET environment and what to expect of the next release. Sample code is used extensively to illustrate feature sets and illuminate topics covered. The accompanying CD includes this sample code as well as scripts and utilities. Rahul Sharma also shares his tips for optimizing applications' performance with adjustments to code, settings, and hardware. He alerts readers to common errors and fixes, and provides a checklist to guide readers through the installation and verification of the database server's stability. Rahul has translated his experience into knowledge and ready-to-use tools that database administrators and developers need to realize the many benefits of moving to SQL Server 2000. 0201752832B02212002

Table of Contents:
(NOTE: Each chapter concludes with a Summary.) Preface. Acknowledgments. 1. SQL Server 2000 Overview. SQL Server Editions. Hardware Requirements for Installation. Installation of SQL Server 2000. Debugging Installation Issues with SQL Server 2000. Upgrading from a Previous Version of SQL Server. Edition Upgrades. Adding Components to an Instance of SQL Server 2000. Uninstalling SQL Server 2000. Unattended Installs. Installing SQL Server Using SMS. Rebuilding the Registry. Multiple Instances. Default Instances. Named Instances. File Locations for Multiple Instances of SQL Server. Network Protocols. Collations Support for Internationalization. Checklist for a Successful Install of SQL Server. Maintenance and Integrity Checks. I. NEW FEATURES AND IMPROVEMENTS OVER SQL SERVER 7.0. 2. Enhancements and Changes to Existing Features. Feature Sets. Fully Web-Enabled. English Query. More Scalable and Reliable. BizTalk Server 2000. Multi-Instance Support. Reduction in Development Time. Accessing Data via Internet. Web-Based Analysis. VI SAN Support. Indexed Database Views. T-SQL Debugger. User-Defined Functions. New Data Types. Cascading DRI. Distributed Partitioned Views. OLAP Services. DTS. INSTEAD OF and AFTER Triggers. Collation Enhancements. Full-Text Search Enhancements. Multiple Instances of SQL Server. Index Enhancements. Failover Clustering Enhancements. Net-Library Enhancements. 64-GB Memory Support. Distributed Query Enhancements. Kerberos and Security Delegation. Backup and Restore Enhancements. Scalability Enhancements for Utility Operations. Text in Row Data. 3. XML Support in SQL Server 2000. Generating XML with the SELECT Statement. Generating XML over the Internet. Retrieving XML-Formatted Data from SQL Server. Reserved Characters. XML Templates. Using EXPLICIT Mode. XSL Stylesheets. XML System Stored Procedures. OPENXML. Writing Queries Against an XML Document. OPENXML Parameters. XPath Expression to Identify the Nodes to Be Processed (rowpattern). Description of the Rowset to Be Generated. Mapping Between the Rowset Columns and the XML Nodes. Specifying Metaproperties in OPENXML. Examples. 4. Engine Enhancements in SQL Server 2000. The Enhancements. Interacting with Data. Reading Data More Effectively. Top n Enhanced. Shared Scans. Concurrency. Tables and Indexes. In-Row Text. New Data Types. Indexes. Logging and Recovery. Logical Log Marks. Shrinking the Transaction Log. Recovery Models. Improved Backup Functionality. Administrative Improvements. Database Verification. Database State Control. System Process IDs and Units of Work. Dynamic Tuning. Data Storage Components. Memory Pool. Files, Filegroups, and Disks. 5. DTS Enhancements. New Features in DTS. New Custom Tasks. Enhanced Logging Facilities. Saving DTS Packages to Visual Basic Files. Using the Multiphase Data Pump. Using Parameterized Queries. Using Global Variables to Pass Information Between DTS Packages. Using DTS Designer. Tasks: Defining Steps in a Package. Workflows: Setting Task Precedence. Connections: Accessing and Moving Data. Data Pump: Transforming Data. Data Pump Error Logging. Data Pump Phases. Options for Saving DTS Packages. DTS as an Application Development Platform. 6. Profiler and Index-Tuning Wizard Enhancements. SQL Profiler Terminology 113Starting Profiler Trace. General. Events. Data Columns. Filters. Templates. Defining Your Own Trace Using Stored Procedures. Defining a Server-Side Trace. Known Bug in SQL Server 2000 Profiler. Symptoms. Cause. Resolution. Index Tuning Wizard. Analyzing Index Tuning Wizard Output. Starting the Index Tuning Wizard. Itwiz.exe. 7. Replication Enhancements. Types of Replication. Replication Options. New Features and Improvements. Implementing Replication. Merge Replication. Transactional Replication. Queued Updating. Transforming Published Data. Replication Usability. Log Shipping. Configuring Log Shipping with the Database Maintenance Plan Wizard. Configuring Log Shipping Manually. 8. New Data Types. Bigint. sql_variant. Table. 9. User-Defined Functions. Types of User-Defined Functions. Scalar Functions. Table-Valued Functions. Obtaining Information About Functions. 10. Indexed Views. Performance Gains from Indexed Views. Benefits of Using Indexed Views. Query Optimizer. Design Considerations. Creating an Indexed View. Using SET Options to Obtain Consistent Results. Using Deterministic Functions. Additional Requirements. Maintaining Indexed Views. 11. Trigger Alternatives. Types of Triggers. AFTER Triggers. INSTEAD OF Triggers. Core Difference Between INSTEAD OF and AFTER Triggers. Which Trigger to Pick? Designing INSTEAD OF Triggers. 12. Meta Data Services Enhancements. Meta Data Fundamentals. Meta Data Is Abstract. Meta Data Has Context. Meta Data Has Multiple Purposes. Meta Data Management. Information Model Fundamentals. Information Model Building Blocks. Standard Information Models. Importance of Information Models. New Features in Meta Data Services. Meta Data Browser Enhancement. XML Encoding Enhancements. XML in Meta Data Services. 13. Tool Enhancements. Query Analyzer. Templates. Using Templates in SQL Query Analyzer. Building Your Own Template. Copy Database Wizard. Uses of Copy Database Wizard. Copy and Move Process. 14. Backup and Recovery Enhancements. Backup and Restore Architecture. Capabilities. Recovery Models. Simple Recovery. Full Recovery. Bulk-Logged Recovery. Switching Recovery Models. 15. Analysis Services Enhancements. Cube Enhancements. Dimension Enhancements. Data Mining Enhancements. Other Enhancements. 16. Distributed Partitioned Views. What Are Distributed Partitioned Views? How Distributed Partitioned Views Work. Building Distributed Partitioned Tables and Views. How the Query Processor Uses Distributed Partitioned Views. Designing Systems That Maximize Distributed Partitioned View Performance. Designing Partitions. Designing the Application Tier for Load Balancing. Designing for High Availability. Backing Up and Restoring Federated Database Servers. Updatable Partitioned Views. Table Rules. Column Rules. Partitioning Column Rules. Data Modification Rules. INSERT Statements. UPDATE Statements. DELETE Statements. Distributed Partition View Rules. 17. T-SQL Debugger. 18. Cascading Declarative Referential Integrity. Cascading Referential Integrity Constraints. Multiple Cascading Actions. Triggers and Cascading Referential Actions. Cascading Referential Constraints Catalog Information. 19. Collation Enhancements. How Character Data Is Stored. International Data and Unicode. Sort Order. What Is Unicode and How Can It Be Used? UCS-2. UTF-16. UTF-8. Data Types in SQL Server 2000. Non-Unicode Text Types: char, varchar, text. Unicode Text Types: nchar, nvarchar, ntext. Date/Time Types: datetime, smalldatetime. Collation in SQL Server 2000. Collations Specified at Multiple Levels. Collations at the Server Level. Collations at the Database Level. Collations at the Column Level. Collations in Expressions. Considerations Before Changing the Collation of a Database. Collation Precedence. COLLATE Keyword. Limitations of the COLLATE Keyword. Issues with Defining Collation at the Column Level. LCIDs and Collations. ISO Strings and Collations. Multilingual Data in the User Interface. Multilingual Information in the Grid and SQL Panes of SQL Query Analyzer. Format Issues in the Query Designer. Sort Order. Double-Byte (DBCS) Characters. Getting to SQL Server Data (Data Access Methods). Multilingual Transact-SQL. II. ADVANCED DBA TOPICS. 20. SQL-Distributed Management Objects. What Is SQL-DMO? SQL-DMO Object Model. ExecuteImmediate Method. Script Method. SQL-DMO Code for Executing a Job. SQL-DMO Code to Play with Triggers. 21. Microsoft Desktop Engine. Portable and Compatible. Minimum Requirements. Features and Limitations. MSDE Install. Scenarios for Using MSDE. Developing Applications with MSDE. Sample Application. MSDE Service Pack1. 22. Administration. Database Consistency Checks (DBCCs). Undocumented DBCC Commands. Information Schema Views. Orphaned Sessions. Issues with Orphaned Sessions. Resolving Issues through the Query Analyzer. Changing the Check Frequency. Linked Servers. Creating Linked Servers. Setting the Linked Server Options. Creating Logins for the Linked Server. Querying the Linked Server. 23. Debugging Database Performance Issues. Performance Monitor or Task Manager? Performance Monitor. Using the Performance Monitor. Which Process Is the Bottleneck? Task Manager. Performance Monitor Counters. CPU Performance Counters. I/O Performance Counters. Memory Performance Counters. Network Performance Counters. SQL Server Performance Counters. Settings. Event Viewer. SQL Server Profiler. Hardware Issues. Database Setup. SQL Tips. Create and Use Proper Indexes. Use Clustered Indexes. Short Index Keys. Use Covering Indexes. Help SQL Server Choose Indexes. Estimate Index Selectivity. Use the SQL Server Query Optimizer. Use Indexes Effectively. Use Foreign Keys for Joins. Use Concatenated Keys Correctly. Use Only Selective Indexes. Avoid NULL Checks. Avoid Functions and Expressions on the Indexed Columns. Avoid the Inequality Operator. Avoid Full Table Scans. Use EXISTS to Check for the Existence of a Record. Replace NOT IN with NOTEXISTS. Large Insert, Update, and Delete SQLs. Do Not Use Positional Numbers. Use Group Functions Carefully. 24. SQL Server 2000 Service Pack 1. Before the Install. Installing Service Pack 1. Install Database Components SP1. Install Analysis Services SP1. Install Desktop Engine SP1. Removing Service Pack 1/Rolling Back to the Previous State. Fixing Bugs. Fixes for MDAC. SQL Server 2000 Fixes. III. COMPARISON WITH ORACLE 9I. 25. Oracle 9i vs. SQL Server 2000. Database Definition. Database System Catalogs. Physical and Logical Storage Structures. Striping Data. Transaction Logs and Automatic Recovery. Networks. Comparison of Features Provided by the Two RDBMS. New Features in Oracle 9i. 26. Migrating from Oracle 9i Databases to SQL Server 2000. Database Security and Roles. Database File Encryption. Network Security. Login Accounts. Groups, Roles, and Permissions. Database Users and the Guest Account. Sysadmin Role. db-owner Role. Defining Database Objects. Database Object Identifiers. Qualifying Table Names. Creating Tables. Table and Index Storage Parameters. Views. Indexed Views/Materialized Views. Indexes. Clustered Indexes. Nonclustered Indexes. Index Syntax and Naming. Index Data Storage Parameters. Ignoring Duplicate Keys. Indexes on Computed Columns. Using Temporary Tables. Data Types. Using Unicode Data. Object-Level Permissions. Enforcing Data Integrity and Business Rules. Naming Constraints. Primary Keys and Unique Columns. Adding and Removing Constraints. Generating Unique Values. Domain Integrety. Referential Integrity. User-Defined Integrity. Delaying the Execution of a Stored Procedure. Specifying Parameters in a Stored Procedure. Triggers. Transactions, Locking, and Concurrency. Transactions. Locking and Transaction Isolation. Dynamic Locking. Changing Default Locking Behavior. Handling Deadlocks. Insert Statements: The Forgotten Culprit. Remote Transactions. Distributed Transactions. Two-Phase Commit Processing. SQL Language Support. SELECT and Data Manipulation Statements. SELECT Statements. INSERT Statements. UPDATE Statements. DELETE Statements. TRUNCATE TABLE Statement. Manipulating Data in Identity and Timestamp Columns. Locking Requested Rows. Row Aggregates and the Compute Clause. Join Clauses. Reading and Modifying BLOBs. Functions. Conditional Tests. Converting Values to Different Data Types. User-Defined Functions. Comparison Operators. Pattern Matches. Using NULL in Comparisons. String Concatenation. Control-of-Flow Language. Declaring Variables. Assigning Variables. Statement Blocks. Conditional Processing. Repeated Statement Execution (Looping). GOTO Statement. PRINT Statement. Returning from Stored Procedures. Raising Program Errors. Implementing Cursors. Declaring a Cursor. Opening a Cursor. Fetching Data. CURRENT OF Clause. Closing a Cursor. Developing and Administering Database Replication. Moving Data and Applications. IV. SCRIPTS AND UTILITIES. 27. Administration and Utility Scripts. Scripts. Disable Constraints. Enable Constraints. USP_Find_Lock. USP_Lock_Info. Greatest. Update Statistics. USP_Active. Objects. Number_Of_Rows. USP_Update_One_Table. USP_System_Info. USP_Null_Columns. USP_SetUP_Paths. USP_Identity_Columns. USP_DB_File_Info. USP_NOIndexes. USP_RenameDB. USP_ForceDropDB. USP_Trace_BlackBox. Registry_Info. USP_KillConnections. USP_FK_PK. USP_DefragDatabase. USP_DBUpdate. USP_Calc_Space. BackUp.vbs. USP_PingServers. Schema Comparison Scripts. USP_MonitorServices. USP_DTSReplaceOwner. DTS Packages. Refresh Databases. Back Up Databases and Version Control. ScriptData. ExportPackages.vbs. ImportPackages.vbs. Executing DTS Through T-SQL. Copying Databases from Server to Server. Method 1. Method 2. Method 3. Method 4. Method 5. V. SQL SERVER.NET. 28. SQL Server 2000 and .NET. What Is Microsoft.NET? From Products Vendor to Services Vendor. Web Services. .NET Servers. SQL Server 2000 and .NET. Next Release of Microsoft Server. Windows XP and .NET. Appendix. Index. 0201752832T03082002

About the Author :
Rahul Sharma is a senior database administrator for Manhattan Associates, Inc., and a columnist for both Swynk.com and SQLServerCentral.com. He has been working with Microsoft SQL Server since the release of SQL Server 6.5 and is currently working with both SQL Server 2000 and Oracle 9i. He is a Microsoft Certified Professional with more than six years of experience in database administration. 0201752832AB11162001


Best Sellers


Product Details
  • ISBN-13: 9780201752830
  • Publisher: Pearson Education Limited
  • Publisher Imprint: Addison Wesley
  • Language: English
  • Sub Title: A Guide to Enhancements and New Features
  • ISBN-10: 0201752832
  • Publisher Date: 19 Mar 2002
  • Binding: SF
  • Returnable: N


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Microsoft SQL Server™ 2000: A Guide to Enhancements and New Features
Pearson Education Limited -
Microsoft SQL Server™ 2000: A Guide to Enhancements and New Features
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Microsoft SQL Server™ 2000: A Guide to Enhancements and New Features

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    Fresh on the Shelf


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!