What about database development

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,

Functions of each database in the SQL Server System

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.

14 skills in Database Design

[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's use of Indexes

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

FAQs about using logexplorer [reprinted]

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

MSSQLServer character splitting Function

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

[Reprinted] use the SQLServer maintenance plan to implement regular automatic Database Backup

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

SQLServer remote database backup

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

Similarities and differences between Redis usage and Memcached

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

Analysis of MySql and SqlServer Partitioning technology

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.

Exploring SQLServer virtual log files

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

Install oracle10grac (1) asm + bare Device on wmware

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,

DB2 database uses backup to restore an instance from a different machine for analysis

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:

Oracleswap100 % Case Analysis

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

OCP knowledge point explanation-Undo rollback and submission

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:

OracleLOCK internal mechanism and Best Practices series (5) provides an SQL example that causes a deadlock

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

Exercise caution when setting binlog_format = MIXED

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.

Group in SqlServer

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)

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

Performance scalability of relational databases and selection criteria of NoSQL Products

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

Total Pages: 12780 1 .... 11011 11012 11013 11014 11015 .... 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.