I checked online and found that SQL server 2008 has been released. I’d better start with the basics first.
Common versions of SQL server2000 are: Enterprise Edition, Standard Edition, Personal Edition, and Development Edition.
Enterprise Edition: Full-featured, used in large and medium-sized product service processors, supporting large websites, online transaction processing, and online analytical processing performance.
Standard Edition: Suitable for small workgroups, does not support the functions of large databases, data warehouses and websites, and does not support all relational database engine functions.
Personal Edition: Mainly suitable for mobile users, it has fewer transaction processing replication functions than the Standard Edition.
Development version: A version for application development that supports all other functions except graphical settings. It is mainly suitable for programmers to use SQL server as a data storage area when developing systems. Although it has complete functions, it is only authorized for a development and A test system, not a production server.
It is recommended to install the enterprise version to learn. Of course, you can also install the development version.
SQL server features: The database engine fully supports XML; it can be installed on multiple versions of Windows. Support for federated servers, indexed views, etc. can upgrade SQL server2000 to the performance level required by the largest web sites; distributed queries can reference other types The data in the database ensures the integrity of data updates in the distributed database. Replication can maintain multiple copies of the data. These users can modify and merge them to the publishing server to ensure data integrity and minimize the overhead of managing concurrent modifications to the database. ;Easy to install, deploy and use; Includes data warehouse functionality.
Commonly used tools are as follows:
1 Enterprise Manager - a public service management environment based on the Microsoft Management Console, providing management of all SQL server objects (including tables, views, stored procedures, triggers, roles, rules, user-defined database types, etc.), including Backup, copy, restore and other functions.
2 Service Manager - Start, pause and stop servers and services in the lower right corner of the taskbar; services provided include SQLserver, SQLserver agent and distributed transaction coordinator.
3 Query Analyzer - The graphical query analyzer is used to input and execute Transaction-SQL statements and quickly view the results, which is very helpful for mastering the SQL language and understanding the management of SQL server.
4 Client Network Utility - Configure the client's network connection management and measure the client's network library, etc. Don't change it until you understand it well enough.
5 Profiler - An event is any behavior in the SQL server engine. Do not track and monitor events too much to avoid taking up too many resources.
6. Server network usage tool - a database management tool installed on the server side to configure server-side connection and setting parameters. The client network utility program must be set according to the server-side network usage program to ensure normal communication.
7. Import and export data - using DTC to help us convert data between different databases.
8 Online help documentation - Index and full-text search capabilities to find the information you need.
Installation and configuration
The enterprise version is generally installed on win NT or windows 2000 advanced server and higher, and the standard version is generally installed on the service system. My machine is XP, so I installed the development version. In terms of software requirements, it is said that the requirements can basically be met. Hardware requirements are configured based on the size of the database, the number of concurrent users, and the expected throughput of transactions.
Database files - database, data, and log information are stored in different files. Including the following three categories: primary data files (.mdf files) include database data information; secondary data files (.ndf) can have multiple or none in a database; log files (.ldf
file) Each database has a log file.