I learned database (1) -- when I learned about database development, I recorded and thought about data collection in MSSQL, and put my learning experience in it, so don't read the title if you're bored. The content in it is quite good. In the future,
The MasterMaster database stores all the databases placed on the SQLSERVER entity, and it is also a binder for fixing the engine. If you do not use the primary database, SQLSERVER cannot be started. Therefore, you must carefully manage the database.
[Switch] 14 skills in Database Design 1. The relationship between the original document and the entity can be one-to-one, one-to-many, and many-to-many. In general, they are a one-to-one relationship: an original document corresponds to only one
SQL Server uses filters to filter out some records when writing SQL statements for indexing. SQL statements are short for filtering conditions: SARG (searchargumentSARG) amount6000
SQL Server uses filters to filter out some records when writing SQL
1) when the database is completely different and the log backup is performed, the unused entries in the transaction log are deleted, and then the Log Explorer attempts to view the log, prompting Nologrecordersfoundthatmatchthefilter, when
Insus. NET previously used the nodes () method of XQuery to write a function, which is a function for MSSQL character splitting. Today I am going to learn SQL and try to write another one: QUOTED_IDENTIFIER -- Author: Insus. NET -- Createdate: 2013-0
For data security considerations, You need to regularly back up the database in SQLServer. The backup database is generally performed in the early morning when there are basically no database operations, so we cannot ask the Administrator to back up
In some database-related projects, regular database backup is often required. It is quite easy to back up data to the local machine on a regular basis and the task can be completed. However, if the entire machine crashes, it makes no sense to back
What is Redis? Two sentences can be summarized as follows: 1. is a completely open-source free key-value memory database 2. usually considered as a data structure server, mainly because of its rich data structures strings, map
What is Redis? Two
I. mySQL 5.1 and later versions have added the Partitioning technology, which is different from the previous table sharding technology. The previous table sharding technology sets a large table level (according to certain logic) into multiple tables.
SQLServer divides transaction log files into multiple VLF (VirtualLogFile), that is, virtual log files. 1. Four statuses of VLF: 1. active. Indicates an active transaction (unfinished transaction) in VLF ). 2. recov
SQLServer divides transaction log
Operating system versions: RHEL5.5-64bit, oracle10g, vmwareworkstation6.5, and clusterware10.0.2; dual NICs for two virtual machines; 40 Gb local disk and 9 GB shared disk; select allocate all
Operating system versions: RHEL5.5-64bit, oracle10g,
A production DB2 database needs to back up all its data and then restore and import it to a test database. Some problems have been encountered and finally solved successfully, the steps are recorded for easy learning and analysis. System Environment:
Operating system version: centos5.864bit database version: 11.2.0.1 Problem description: recently added the memory to 32 GB for the database, and increased the MEMORY_MAX_SIZE parameter to 28 GB, MEMORY_TARGET parameter to 24 GB.
Operating system
I. Summary of use of rollback segments: 1.1Seq Sequence Value: Step 1: Each rollback block header has a SEQ value. When the transaction extends to the new area, the SEQ in the new area is the SEQ plus 1 in the previous area. For example, Step 2:
Provides an SQL example of deadlock definition: in a broad sense, it includes the operating system application database. If two processes (sessions) hold each other's resources, they always wait for the other to release, this situation may cause
My. cnf configuration file binlog_formatMIXED, and use the default isolation level REPEATABLE-READ, there is a major problem, resulting in master-slave data inconsistency. The following example shows that the master and slave nodes are both MySQ.
1. Groupby can merge the same data into a group, and the grouped data can be considered as a temporary table. Note that if the SQL statement contains the where condition, the groupby must be placed after the where clause. 2. You can specify multiple
SQLSERVER uses Windows authentication on the LAN to connect to another SQL server in the LAN (not a domain environment) previously, even MSDN said that connecting to another SQL server in the LAN must be a domain environment if you want to use
I. Relational databases are facing the pressure of data access. Generally, the solution steps (taking MySQL as an example) 1. Master-slave replication achieves read/write splitting or distributed read; 2. There are many read requests, you can add a
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