Database Administrator

Knowledge points that must be learned when using the IBM DB2 database: 1. After installing the DB2 database, you can operate it through the command line or graphical interface,If your database server is not on the local machine, you need to

Code for trigger Creation Create Trigger TG_ProjectNameOn table1After UpdateAsUpdate table2Set [project name] = B. Project NameFrom table2 a, inserted BWhere a. ProjID = B. ID Description of Inserted and Deleted in the trigger. Two

In database design and management, the WHERE clause is undoubtedly one of the most frequently used clauses. So are you really good at using this clause? I can't see it. The following suggestions can help you make full use of the WHERE clause

We often use joint queries for two tables. Sometimes we use internal connections, full connections, and left and right connections. Is it very complicated? The following is a demonstration of their differences. First, there are two tables:

Sysbase is a pioneer in column-based databases. Sysbase IQ 15 is the latest column-based database of Sybase. It has powerful functions, including fast data loading, ultra-high-speed analysis performance, powerful intelligent business analysis, and

Infobright supports all the original MySQL Data Types. The Integer type is more efficient than other data types. Use the following data types as much as possible: TINYINT, SMALLINT, MEDIUMINT, INT, BIGINT DECIMAL to minimize the number of DECIMAL

Before OMF (managed files) is available, the database administrator needs to care about two issues when creating data files. The first is what kind of name should be taken for this data file, and the second is to consider whether the newly created

The database history can be traced back to fifty years ago, when data management was very simple. Data is processed by a large number of classification, comparison, and table-drawn machines running millions of punched cards. The running results are

1) Prepare test data If you have less time to talk, go straight to the subject. Create a simple employee table t_hierarchical: Emp employee ID Direct superior of Mgr employees (Mgr itself is also an employee) Emp_name employee name Insert

The method functions are provided below:1. Declare an external function to obtain the temporary path of the system. FUNCTION ulong GetTempPath (ulong nBufferLength, ref string lpBuffer) LIBRARY "kernel32.dll" alias for "GetTempPathA"2. Core

This article lists the Common commands for Oracle Database intrusion: 1. su-oracle is not required. It is suitable for use without a DBA password. You do not need a password to enter the sqlplus interface. 2. sqlplus/nolog, sqlplus system/manager,

This article uses SQL Server 2 K as an example to illustrate the specific implementation process of connecting SQL Server to the Oracle Server. 1. Install the oralce client software and sqlserver2000 software on the PC. 2. Configure the tnsnames.

When you roll back a long-running transaction in Oracle Database 10g-whether it is a parallel instance to restore the session or a rollback statement executed by the user-all you need to do is to view the view V $ SESSION_LONGOPS evaluate the time

With the development of Internet technology, Web has been increasingly applied to all walks of life. Traditional applications based on the big machine or C/S structure are gradually replaced by the B/SBrowser/Server structure. The database, as a

A few days ago, due to some data corruption in the MySQL database, I tried to recover the data, and then sorted out the following documents for your reference. If you have similar problems in the future, you can avoid detours, solve the problem as

Date and time functions are very useful for creating a site. The website owner is often interested in when data in a table is updated. Using Date and Time Functions, you can track changes to a table in seconds. The DATE and TIME types are DATETIME,

We often receive calls from customers. My database logs are full. Is there any way to quickly clear them? Especially for some beginner DB2 users to maintain a large data volume system, this is almost a problem they will inevitably encounter. We

Any database may have certain security risks during its long-term use. For database administrators, a complete set of database backup and recovery mechanisms should not only be intended for the secure operation of computer operating systems. When

BKJIA quick translation] As mentioned in sections 1st and 2nd, there are several relatively easy steps you can take to improve performance, one of these steps involves the use of automated tools to "Guide" you to write SQL statements, there are many

During the installation process, you can upgrade the existing instance of Analysis Services to migrate the existing Analysis Services database, or run the migration wizard after installation. This topic describes how to use the migration Wizard to