Database Administrator

CTE statement structure and CTE recursive query in SQL SERVER CTE statement Structure A common table expression (CTE) can be considered as a temporary result set defined within the execution range of a single SELECT, INSERT, UPDATE, DELETE, or

This topic describes how to identify the current SQL Server version number and the corresponding product level or service package (SP) level. It also describes how to identify the specific version of SQL Server 2000 or SQL Server 7.0 used.How to

Kill session is one of the common problems that DBAs encounter. If you kill a session that you do not want to kill, it will be destructive, so try to avoid such an error as much as possible. You should also note that, If the kill session belongs to

This article mainly organizes Forum content. Forum address: http://bbs.et8.net/bbs/showthread.php? T = 1026112) Many people have encountered that RAID5 is suspended on the server. After a disk is dropped, the second disk is immediately

The oci function is used to connect to Oracle using php. The following documents are provided: 1. install Apache and php packages. yum install -y httpd php*  2. download Oracle component

Today, a friend asked me why 11g exp files cannot be imported into 9I? Due to the incompatibility of exp/imp tools, when importing a database of a higher version to a lower version, you need to use the exp/imp tool of a lower version for import and

This article was sponsored by 51cto.com and first launched in the dark world. To be honest with SQLServer2005, I am not very familiar with it. I will share my research results this afternoon. Use the Navicat for SQL Server tool to manage databases.

Mathematical functions 1. Absolute Value S: select abs (-1) value O: select abs (-1) value from dual 2. INTEGER (large) S: select ceiling (-1.001) value O: select ceil (-1.001) value from dual 3. Smaller values) S: select floor (-1.001) value O:

The databases used in the company are in simplified Chinese and Traditional Chinese versions. I am using SQLServer in this project in the Traditional Chinese version, but I need to use the data of another SQL server project in the Simplified Chinese

Recently, I have been asked questions about MySQL Query Cache. I just want to sort out some MySQL Query Cache content for your reference. As the name suggests, MySQL Query Cache is used to Cache Query-related data. Specifically, the Query Cache

Deadlock) refers to the state in which processes are permanently blocked. SQL can detect deadlocks and terminate a transaction to intervene in the deadlock State. A typical example of A deadlock between two processes is: Obtain lock A in process T1

New array mobile day Q: our current RAID will soon be filled up, so we need to move some SQL Server 2005 databases to other locations. The new array is ready and I have been preparing for the mobile database. I just found that one of the databases

 I. Optimized disk configurationOracle is a disk I/O-intensive application. Make sure that you configure the disk and file system properly: Run the disk fragment program before creating a data file on the disk.To securely organize disk fragments,

Objective: To insert data in an excel file into an oracle database Steps: 1. Open MicroSoft Excel 2000 2. File (F) → new (N) → workbook → 3. After the data is input, the storage disk is test.xls, 4. File (F) → save as (A) → The storage type is:

I. Runtime Environment SQL> select * from v $ version;BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-ProdPL/SQL Release 10.2.0.1.0-ProductionCORE 10.2.0.1.0

BKJIA exclusive Translation] This article provides a general introduction to the automatic database maintenance task management in Oracle 11g. The article is concise for two reasons: 1. Most people have not touched these settings. Even so, if you

In the Oracle database system, there are two authentication methods for a user to log on to the Oracle database as a privileged user: that is, authentication is performed using the Integrated Identity Authentication with the operating system or

If two user processes lock different resources and attempt to lock the resources locked by the other user, a deadlock will occur. At this time, SQL Server automatically selects and terminates one of the processes to remove the deadlock, so that

1. Two forms of temporary tables. In SQL Server databases, temporary tables are classified into global temporary tables and local temporary tables. These two types of tables are very different, mainly in terms of name, visibility, and availability.

MySQL uses the value of the environmental variable TMPDIR as the path name of the directory for saving the temporary file. If TMPDIR is not set, MySQL uses the default value of the system, usually/tmp,/var/tmp, or/usr/tmp. If the file system that