1. Microsoft SQL Server 2000 Overview
SQL Server system
SQL Server 2000 features and new features
Summary of this chapter
Microsoft SQL Server 2000 is an associative repository (RDBMS). Such a library category classification formation architecture, which makes the relevant information, forms a table, table, and table, can be associated with association data. The system administrator can enter the server, change the data type, manage, and process server resources through the application. SQL Server is also a SCALABLE DATABASE, that is, SQL Server can support multi-user users to process a large amount of information in the database.
SQL Server has been launched in 1989, which continues to improve the ductility, integrity and simplification of the product. In this chapter, we will introduce two use environments of SQL Server, and will also introduce the features and new features of SQL Sever 2000.
The SQL Server System SQL Server system can be installed on the job system platform of the main / slave architecture, or a stand-alone servo host. As for which system is to be installed, you should first evaluate how many users will work in the database and use the database. In this section we will view these two setup systems. The master-slave system master is divided into two-layer and three-layer architecture. SQL Server software and database are placed in a central computer called the database server, whether it is installed, and let the user perform the user's end on its own computer. The two architectures are in that the user enters the library server (two-layer architecture) through the app on the client, or is transmitted into the database server (three-layer architecture) ). To be more specifically, in two layers of architecture, each user end can directly enter the database server through the network connection, so the user ends to perform business logic and the program code that can make the result display. Because the client under this architecture can perform these two prices, it is called "Thick Client". Figure 1-1 is a brief map for two-layer architecture. Since this connection can make each of the connectors occupy system resources (such as memory or resource locking), there is not much fashionable user connection in the client connection. When the number of connectors increases, the three-layer architecture can be considered.
Figure 1-1 Two-layer master / off frame AAA configuration system
As mentioned previously, the three-layer architecture is more than two layers of computers called the application server. The result is displayed through the application server execution code. The user under this architecture is called "Thin Client". Applications of the application usually perform business logic; and the application of this can be multiplexed, meaning that this application can be allowed to be accessed by multiple users. Application Server can be connected to the database server, access data and display the execution result to the user end, as shown in Figure 1-2. The advantage of the three-level architecture is to avoid being connected to the server database directly, and the server resources are occupied. The concept of this connection architecture is called connectivity, and the wiring area is to let the client throw the demand in (correctly, "伫 于 于") a common area, waiting for the connection. When a connection is over, the next user can connect up. As far as conceptually, the connection set allows you to configure traffic in the central area, to adjust the workload of the server (traffic can be configured through soft), avoid multi-person connection to reduce system performance. You can use the COM components built in Microsoft IIS or Microsoft Windows 2000 to reach the connection set. As for the details of the erection, it is not within the scope of this book.
Some companies' systems and websites need to use more than one server handling data. SQL Server 2000 The split data sheet function can span multiple servo, reduce the load amount of each serveometer. Its details can be referred to this book
Table system
SQL Server can also be a database that is executed independently on a desktop or notes, so that the table system is known. The same computer can also include a database that performs an application and SQL Server. Because only one computer is needed under this system architecture, you don't need to consider the remote connection; the user only needs to connect to the SQL Sever on your computer on your computer.
The table system is suitable for single user access library materials, or fewer users share a computer but does not enter the information inventory in the same time. For example, a small shop may have only one computer. When several employees need to access customer data or sales information, they will use this computer to use this computer. Table system is ideal for small shoppers that are not large in this type of data and database.
SQL Server 2000 features and new features SQL Server 2000 have many new features and features, we can't detail here, but we will introduce several more than a more worthless part here. These features make SQL Server 2000 easy to manage and use, and strengthen the old version of the function, making it suitable for online transaction processing of various sizes, such as data warehousing, e-commerce applications. In this section, in addition to describing the new features of SQL Server 2000, we will tell you where to find relevant information. New Features This section will tell you the characteristics and new features of the servo end. More detailed information can be found in the following chapter. Supporting the Extension Memory SQL Server 2000 Enterprise Edition can use the Windows 2000 Address Windowing Extensions (AWE) API to support the address of the large-capacity memory space. SQL Server can now support 8GB memory on Windows 2000 Advanced Server, or support to Near 64 GB of memory on Windows 2000 Datacenter Server. In addition to these two versions of job systems, such as Windows 2000 Professional and Windows 2000 Server does not support AWE features. Some new SQL Server parameters (such as awe enable) allow SQL Server to use AWE.
Related Information Reviews The AWE Enabled Option in the Book on the line can get more details.
SQL Server multi-execute individuals with SQL Server 2000, you can execute several SQL Server execution individuals on a computer. Each executable individual has its own system with its own database. Application Connects to perform individuals on a single computer, and its method is nothing different from the executing individuals connected to different computers. You can use SQL Server installation disc to generate an individual. A SQL Server 6.5 or 7.0 execution individual can establish a correlation with multiple execution of the SQL Server 2000, but SQL Server 6.5 and 7.0 execution individuals cannot exist at the same time. You can use the execution individual to group the application group, so the application can be specified on a particular execution individual. This can reduce conflict - because each of the performed individual data libraries perform some daily work (such as data backup, completion of job, establish index, statistical update, or reconstruction index, etc.) is operated independently.
Distributed Split View Table Dispersion Division is a new feature that SQL Server 2000 is worth noting. Some websites or library systems often need many high-order servo to cope with huge transmission, and this feature is important for such websites or databases. You can establish a horizontal segment across these machines that perform SQL Server and include a visual table for all servo members. It has the same appearance on each server, so that all servers' splitting tables look a whole rather than one. Application can reference this view table without knowing which server is located. Related Information Inline Series Establishment of Split Viewheets, you can find more details and guidelines related to the split checkpoint.
Fault-tolerant shift cluster fault-tolerant transmissions (Failover-Clustering) management features have great improvements in SQL Server 2000. The setting of fault-tolerant transfer function has to be removed by fault-to-missemble, but it is now a part of the SQL Server installation process. Compared to past versions, fault-tolerant shifts are easier to install, set, and manage in SQL Server 2000. Listening now, many new features you can apply to management work. Management can be used from any of the clusters to perform fault-tolerance. When the error shift condition occurs, any of the clusters is allowed to jump into the fault-tolerant shift cluster to reset or rebuild the virtual server reset or rebuild in the condensed set. Affect other nodes in the virtual cluster can be used to increase or remove nodes in the fault-tolerant transfer of the Multiple IP address for the virtual server.
You can specify any node in the cluster as a fault tolerance or fault tolerance. If you specify any of the node, it should be jumped in which node should be jumped when it is fault tolerance or fault tolerance.
Related Information For more information on Microsoft Cluster Services, please refer to Chapter 12. In Chapter 12, you can learn what is a cluster, and how to use and plan a cluster in SQL Server.
Support XML Extension Markup Language (XML) is a new standard defined by the W3C Association, mainly to define the performance of information in structured file objects to deliver data between different systems. SQL Server 2000 supports XML. Basically, you can use XML to access SQL Server 2000 via an HTTP communication agreement via a URL. SQL Server 2000 supports XML's support as follows: for XML clause allows you to use Select statement to create an XML file instead of the database-based standard appearance new system pre-save program help you manage XML data XML Update -gram allows you to insert, modify, and delete information in the database. You can use the HTTP communication protocol to perform query or system pre-depicting programs through the URL you can perform multiple SQL state OLE DB Provider accepted by using the URL. The instruction code formed by the XML file can be streaming mode output execution results in Chapter 23, there is more information about XML access to SQL Server. In this chapter, you can also learn some concepts of internet access design. Database Maintenance The SQL Server 2000 has made great enhancements and improvements in the database maintenance operation. These enhanced parts include faster differential backups, parallel DBCC, and a parallel scan using DBCC. Differential backups are backup data for all changes after the last database is completely backed up. DBCC can now utilize the advantages of multiple CPU systems, with multiple CPUs to perform parallel processing, so that the speed of DBCC can be greatly increased. In addition, DBCC no longer needs to lock the information table when the data sheet is scanned, so that even if the DBCC is working, we can still update the information sheet. Reference Integrity When you modify the data line referenced by an external index key (FK), there are two new clauses that allow you to specify the action of SQL Server. These two clauses are ON Update and ON Delete, which can be used in CREATE TABLE and ALTER TABLE statements, and the selective options for both clauses are cascading or no action. When the ON delete option is cascading, if you delete the data in the reference (parent) data sheet, the external index key data sheet will cause the relevant information to be synchronously deleted due to the series. ON Update's option is the same as Cascading. It is reasonable to update the relevant data lines while updating the information line of the parent data sheet. If the ON delete and the ON Update option are No an action, the SQL Server will return an error message and reply to this type of action when the data line of the parent data sheet is removed or the data line is updated. Related Information Online Books You can consult the CREATE TABLE and ALTER TABLE related syntax and more details of these rules.
The full text search SQL Server 2000 provides two powerful new features in full-text search: Change Tracking and Image Filtering. When the index of the full text is updated, the change track can record its change. You can manually clear these record files when you periodically update the index, or set it to Auto option. The image screening feature allows you to prepare an index or query for a file stored in the image data line, resolve the text part of graphics data.
Relevant information about the full text retrieval, please refer to the full text of the book in the online series.
The new data type SQL Server 2000 includes three new data types, which can provide unparalleled flexibility in programming work. The new data type is as follows: Bigint 8-Byte length integer type (maximum integer data type). SQL_VARIANT can be used to store a variety of different data types. TABLE This type of data is allowed to allow the application of the data type of the data table type. SQL Server can be applied to the data type, there is more details on these data types in this section in the SQL Server Profiler SQL Server Profiler provides two new ways to restrict tracking work: according to the size of the tracking file or time according to the tracking file. You can also track several new events. Open Profiler and create a tracking file, press the event tab, expand the new title in the available event category, you can find four new events: Data File Auto Grow, Data File Auto Shrink, Log File Auto Grow and Log File Auto Shrink. The expansion performance title can also be found: Show Plan Statistics, Show Plan All, and Show Plan Text. See Chapter 35 of this book, there are more information about using Profiler. SQL Server Query Analyzer SQL Server Query Analyzer now contains an object browser that allows you to view the database object. Open Query Analyzer, press the tool (Tool menu is also added) and select the item browser, you can find this browser appears on the left side of the Query Analyzer window. Other options for tool menu are object search, manage index, and management statistics. The object search allows you to search for specified objects in the database based on object types (such as visual watch, pre-deposit programs or user data sheets). Managing indexes and management statistics lets you use a graphical interface that is as if Enterprise Manager is provided to manage indexes and statistics. In addition, the query function table has more new options: Display Server Tracking and Display User Statistics. For information on using Query Analyzer, please refer to Chapter 35 of this book. Added a copy function SQL Server 2000 has added some repronding methods. One is the new options provided in the Subscriber option immediately updated. This option is called a column update.伫 伫 更 更 is a specific option for snapshot replication and trading check. Once the column update is enabled, even if the issuer does not connect with the subscriber, the subscriber can also modify the subscription information at the end. When the issuer re-establishes the connection with the subscriber, the transaction of the information is discharged into the column, transmitted to the issuer, and executed in an asynchronous manner. Recycling Relationships can avoid "replica-brought-back source subscribers" transaction status. Related information Please refer to the line of column update on the line.
