MSSQL sorting Rule Summary

What is a sort rule? The sorting rules specify the rules for sorting and comparing string data based on the criteria set for specific languages and regions. SQLServer supports storing objects with different sorting rules in a single database. MSDN

Redis practice (3) Data Type 1 Strings

Redis author SalvatoreSanfilippo once published an article titled Redis Declaration (RedisManifesto). The article lists seven principles of Redis to clarify Redis ideas .. Redis author SalvatoreSanfilippo once published an article titled Redis

[Original] MySQL optimizer optional switch details

MySQL has provided the optimizer Option Switch option since 5.1. In this way, we can force some things that we think should not be done when the optimizer is confused, or when we want to see why the optimizer wants this MySQL has provided the

Oracle10g control file backup to file and manual recovery

Test the use of the alterdatabasebackupcontrolfiletotrace command to back up the oracle10g control file and restore the control file if the control file is lost-Backup Test the use of the alter database backup controlfile to trace command to back up

Example of DB2 Backup Recovery

The following CMDB is the name of the db2 database. This article has been verified by the test environment. 1. Online backup databases do not include archives: db2backupdbcmdbonlineto [path name] package The following CMDB is the name of the db2

Oracle error 1406, extracted column values are truncated

To back up the data, you need to export the complete data of 11 GB users on the server. The client on the machine is oracle10g. Run the command: exp ******* @ ***** file *****. dmp To back up the data, you need to export the complete data of 11 GB

Implementation of auto-expanding partitions in Oracle (use interval partition after 11 GB)

Implementation of auto-expanding partitions in Oracle (use interval partition after 11 GB) Implementation of auto-expanding partitions in Oracle (use interval partition after 11 GB) Create error table: Create sequence seq_error_log_id;Create

Faster data transmission using tar + lz4/pigz + ssh

The previous article introduced how to extract the SCP transmission speed to the maximum extent. With this foundation, we can further use compression to accelerate the transmission speed. Use scp only, transmission rate The previous article

After Oracle is installed, the listener becomes unavailable after the ip address is suddenly changed.

A set of Oracle11g is implemented in the Linux6.2 system, which may be because the operating system is not properly installed. For example, each of the magnetic arrays cannot exceed 2 TB, and the rpm requires x86_64. A set of Oracle 11 GB is

Oracle materialized view test

Materialized views are a special physical table. ldquo; Materialized rdquo; (Materialized) views are relatively common views. A common view is a virtual table, and its application has many limitations, Materialized views are a special physical table.

RMAN configuration retention policy

RMAN retention policies are related to data integrity. Therefore, they are important and set based on user-defined data recovery tolerance. That is to say, based on the recovery needs RMAN retention policies are related to data integrity. Therefore,

Notes when using RMAN to copy a physical standby Database

When using RMAN to copy a physical standby database, it is prone to errors and the error is very strange. I have summarized the issues below. 1. RMAN-04006ORA-12528, boot slave database to nomoun When using RMAN to copy a physical standby database,

Oracle11g new SQLTrace10046 Method

10046 is a tool that anyone familiar with Oracle and SQL tuning is familiar. Two diagnostic events, 10046 and 10053, help us easily understand OracleCBO Optimization 10046 is a tool that anyone familiar with Oracle and SQL tuning is familiar. Two

Brief Introduction to Oracle 10046 event tracking

Generally, 10046 events are not recommended, because if the performance of the instance to be processed is poor, 10046 event tracking may make your instance Generally, 10046 events are not recommended, because if the performance of the instance to

MongoDB NOTE 2: Create, update, and delete documents

Chapter 3 create, update, and delete a document insert a new document: db. foo. insert ({bar: baz}) My understanding: database. set. insert ({key: value}) Note: The insert speed is faster than that of data inserted at a time, because batch insert

Introduction to the LevelDb Series

You may not be clear about LevelDb, but if you are an IT engineer and do not know the following two great-level engineers, your leadership may not be able to Hold IT anymore: JeffDean and SanjayGhemawat. These two are Google's heavyweight engineers,

Physical memory expansion, oracle11gR1 database Parameter Modification

Background: The physical memory of the master and slave machines is doubled. After the memory is expanded, You need to modify the memory parameters related to the database, including the database and operating system. After doubling the memory size

[Original] detailed explanation of PostgreSQL Incremental backup and related examples

PostgreSQL does not have binary logs similar to MySQL, but it has a REDOLOG similar to MySQL and does not have the REDO archiving function. Of course, REDO archiving has been implemented by MariaDB and Percona-MySQL. Then I PostgreSQL does not have

Terminate a session in Oracle

Sometimes it is necessary for oracle to terminate the current session. For example, if you want to perform a management operation, you need to terminate all non-Administrator sessions. The following describes how to terminate sess. Sometimes it is

Solution to Oracle dbstart startup error or no response in Linux and self-startup

After successfully installing Oracle10G in Linux and switching to the Oracle user, you can use rdquo; dbstartrdquo; (in $ ORACLE_HOMEbin) to start the oracle database and report the ldquo error; After successfully installing Oracle10G in Linux and

Total Pages: 12780 1 .... 1983 1984 1985 1986 1987 .... 12780 Go to: GO

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.