Database Administrator

If the primary database fails, Microsoft's SQL Server may crash. Let's take a look at how to deal with such events and learn how to use the Enterprise Manager and query analyzer to repair the primary database. As an administrator of Microsoft SQL

The default MySQL Character Set provided by the system is not gbk. Therefore, it brings great inconvenience to the database promotion and application and the development of Chinese programs, the endless conversion between GBK and UTF8 consumes

Create a custom pinyin function in SQL:Create function f_GetPy (@ Str nvarchar (400 ))Returns nvarchar (4000)AsBeginDeclare @ strlen int, @ re nvarchar (4000)Declare @ t table (chr nchar (1) collate Chinese_PRC_CI_AS, letter nchar (1 ))Insert @ t

The Oracle database provides several different methods for starting and disabling databases. This article describes the differences between these methods and their respective functions.1. Start and close the Oracle databaseFor most Oracle DBAs, the

I installed the desktop version of Hongqi Linux6.0 yesterday. It feels really good, especially for reading and writing in NTFS format. Due to work needs, I made windows xp and Red Flag Linux6.0 desktop Dual Boot in my notebook. I plan to use red

To enable normal display of Your webpage on more servers, add "set names UTF8" (you can select the appropriate encoding, such as gb2312 ), even if you do not add this sentence, you can access it normally. Let's talk about the character set of MySQL.

Install MySQL in Ubuntu Sudo apt-get install mysql-server This should be very simple, and I don't think there is much problem with the installation, so I will not talk about it much. Let's talk about the configuration below. Configure MySQL Note: In

1. Get the current configuration parametersTo optimize configuration parameters, you must first understand the current configuration parameters and running conditions. Use the following command to obtain the configuration parameters currently used

After mysql is installed in Ubuntu 7.10, the password of the root account is blank and you can log on as follows: Mysql-u root Here we need to set mysql security. Set the password of the mysql root User. Use mysqladmin to set the password

If you know more about Oracle databases, it is recommended that you install Oracle databases in linux. Few enterprises will set up Oracle databases on Windows servers and introduce how to install Oracle databases in linux Online, it is rarely

If you use Oracle10G, you may find that many junk tables appear in the database, such as: BINjR8PK5HhrrgMK8KmgQ9nw =, it generally does not affect normal use, but in the following cases, we must delete it 1. These tables occupy space 2, if the use

1. test environment:SQL> create table win_order (Month number (2 ),Total_sales number ); 2. Input data:Insert into win_order values (1,623141 );Insert into win_order values (2,423124 );Insert into win_order values (3,323214 );Insert into win_order

First understand under what circumstances Oracle will generate a ORA-01555 error: Assume that there is a 60 million-Row Table testdb. It is estimated that it will take two hours to scan the entire table once. The reference process is as follows: 1.

It is an important feature to determine whether a DBMS is powerful and whether external stored procedures are easy to create and use. The ASA database has long been supporting the use of C, CLR (. NET), java and other programming languages to create

Environment: CentOS 6.2 64bit VMWare Workstation 7.1 In Linux, the automatic memory management of Oracle 11 GB cannot specify the total memory size greater than this/dev/shm. Otherwise, the following error occurs: ORA-00845: MEMORY_TARGET not

1. Union Operation Select name from test1 Union [all] Select name from test2; When union is used, results are sorted by default, and union all is not sorted, which consumes less resources. However, union all does not perform deduplication ~ 2.

In the Oracle database, the data table cannot execute the update statement because the data table is locked by another user. The solution is as follows: First, execute the following SQL statement: Select * from v $ session t1, v $ locked_object t2

In the database O & M process, Shell scripts provide great convenience for O & M. The passing of shell script parameters as variables to SQL and SQL scripts is also a common situation for DBAs. This article mainly discusses how to pass parameters of

The Oracle monitoring index feature allows us to roughly determine whether an index is used. This is because the index is monitored when statistics are collected in Oracle 10 Gb, which is not produced by SQL statements. In the case of 11g, there is

Unlike SQL Server, which uses # In the stored procedure, you can create a temporary table to cache the data to be processed. Oracle mainly needs to create a temporary table structure physically and use the global temporary table keyword. Syntax: --