Database Administrator

SQL Server database startup and user database Loading Preface This article is a supplement to the previous article. In the previous article, we introduced some problems and solutions encountered during the SQL Server service startup process. Click

Use pt-table-sync to restore inconsistent data In the previous article, pt-table-checksum was used to verify data consistency. This section describes how to verify master-slave data consistency. when determining whether master-slave data is

Summary of new features in Oracle 12C SQL Multiple indexes on the same field Before Oracle 12c R1, a field cannot have multiple indexes in any form. Some may wonder why a field usually requires multiple indexes. In fact, there are many fields or

"You cannot connect to the WMI provider. You do not have the permission or the server cannot access it. ", Wmi cannot be accessed 　　 I recently learned about PowerDesigner and encountered a small problem when I created the PDM model. I thought I was

Oracle 12cR1 Relink error: ld. so.1: skgxpinfo: fatal: libons. so: open failed: No such file or directory, oracledirectory Source:Oracle 12cR1 Relink Error: "ld. so.1: skgxpinfo: fatal: libons. so: open failed: No such file or directory" (Document

Sas memo (1), sas memo Simple dataset output Logs 85 libname saslib base 'e: \ sasdata '; NOTE: The logical Library Reference name "SASLIB" has been successfully allocated, as shown below: Engine: BASE Physical name: E: \ sasdata 86 87 data saslib.

An SQL Server query statement increases tempdb by 55 GB and tempdbby 55 GB. When I operated the server today, the lower right corner of the page prompts "disk C is not enough "! Scared !~Look at drive C, there are still 7 M !!! How can I lose such a

Redis Research (19th)-command attributes, redis research command attributes Different Redis commands have different attributes, such as whether it is a read-only command or an administrator command. A command can have multiple attributes. In some

Django many-to-many relationships, django many-to-Relationship Django 1, 1.7 Use ManyToManyFiled to define multiple-to-multiple relationships. In this example, the Article can be published on multiple publications, and the Publication can have

SQL Server System table and SQL Server System Table Stores all the system information of SQL. Stores metadata related to database services (for example, user databases on the data server, logon accounts on the database server, and tables on the

MySQL-10-mysql programming, linuxmysql Programming MySQL Programming 1. Statement Terminator There are two default values:; and \ g (which can only be used in the command line) You can use the delimiter command to modify the statement Terminator,

SQL query operation process and SQL operation processHere we can see the Query Processing of SQL in the book. In SQL, the query is achieved through the select statement and some auxiliary clauses. Here mysql is used. First, to understand the

Oracle Database Synonyms (SYNONYM), oraclesynonym This tutorial uses examples to illustrate how to create and delete Synonyms (SYNONYM) in Oracle Data ). Concept Synonyms refer to database objects (tables, views, sequences, stored procedures, and

Oracle-specific index type resolution, oracle-index resolution2.1 B-tree index (default type)The B-tree index is a common index in Oracle. When creating an index, it is the default index type. The B-tree index can be a (simple) or composite

[Oracle] Chapter 5 cursor and trigger, Chapter 5 oracle cursor Chapter 5 cursor and trigger Cursor: Implicit cursor: % FOUND, % NOTFOUND, % ROWCOUNT 1.% FOUND usage. The % FOUND attribute returns TRUE only when the DML statement affects one or more

ORA-12547: TNS: lost contact error handling, ora-12547tns Nothing left to worry about. Configure the oracle database to automatically restart with the system. Check the information and find that you need to configure/etc/oratab and rc. local. The $

OLAP introduction (combined with personal work), olap introduction combined with personalOLTP and OLAPTraditional database systems are OLTP and can only provide raw data operations. Analysis is not supported. OLTP system: Performs online transaction

[Mysql] mysql windows configuration file, mysql configuration file The environment is win7 mysql5.6 Test whether the configuration file is available (no msyql configuration in windows has been used before)Query the configuration before modification:

SQL table join diagram, SQL table diagram You can see through the figure below Multi-table queries are classified into internal and external connections. Outer join is divided into left join or left outer join, right join or right outer join, and

ORA-06547: INSERT, UPDATE, or DELETE statements must use the RETURNING clause, ora-06547returning Cause of this error: The returning into clause acts on insert, update, and delete, but the select clause does not work. You should use. The error