NAV: SLTechnology News&Howtos > Database >

• 

  Introduction of common problems in SQL Server and suggestions for quick resolution

  The purpose of this paper is to help users of SQL Server database understand common problems and solve them quickly. These problems are routine database management problems, and provide a general framework of frequently asked questions for many friends who do not have an in-depth understanding of the database. Some of the following questions are recent

  2022-06-01 12:32:15 Views: 219
• 

  Research on the Rights Enhancement of mysql mof

  I accidentally saw this way of raising rights about mysql and studied it while I had spare time. I found that there were many places on the Internet that were not detailed enough, and the research got stuck for a period of time. Use premise: the operating system is windows operating system version should not be too high, 2008 test is not

  2022-06-01 12:32:14 Views: 250
• 

  CentOS 7 installation configuration Redis database

  Redis is a kind of non-relational database based on key-value. Here I will show you how to install and configure Redis under CentOS 7. Get the Redis source code and go to the official website of Redis to obtain the download address of the latest stable version of Redis, http://re.

  2022-06-01 12:32:09 Views: 263
• 

  Talking about Database constraint

  In fact, most of the time, technology and life are closely related to what kind of needs there will be solutions. The database is also such a magical thing. After all, it is a relational database. The data is independent and table-related. Sometimes you need constraints, and sometimes you have to behave and do things properly.

  2022-06-01 12:32:09 Views: 300
• 

  V$sql v$sqlarea v$sqltext

  Take a note here, just to make an impression: V$SQL lists statistics on shared SQL areas without the GROUP BY clause and contains o

  2022-06-01 12:32:03 Views: 263
• 

  Installation and CRUD operation of Mongodb

  What is Mongodb? Mongo DB is an open source non-relational database (NoSql) with a free and flexible document model that allows you to develop smoothly. For Internet applications with large amount of data, high concurrency and weak transactions, MongoDB can

  2022-06-01 12:32:03 Views: 246
• 

  Bulk batch delete data

  Bulk batch delete data 1. In a large table with 100 million rows, deleting 10 million rows of data needs to be completed as quickly as possible with the least impact on other applications of the database. If the business cannot be stopped, you can refer to the following ideas: fragment and reuse according to ROWID

  2022-06-01 12:32:03 Views: 207
• 

  8.1.2 Regional Area

  Benefits of using area: * the router only needs to have the same link-state database as other routers in its area, and there is no need to share the same link-state database with all routers in the entire OSPF area, so the indentation of the link-state database reduces the consumption of router memory * link

  2022-06-01 12:32:01 Views: 242
• 

  Logical volume management of AIX system

  The pre-project needs to deploy several sets of RAC clusters under the AIX environment. Before, there was little contact with the AIX system, but it was hit by basic commands such as creating logical volumes. In fact, there are a lot of information on the Internet. To sum up, it is also convenient for yourself to consult in the future. Create logical volume 1. View all disk devices # ls

  2022-06-01 12:32:00 Views: 296
• 

  Oracle 11g installation

  Hardware preparation: the physical memory is at least 1G. The Linux virtual machine has a capacity of 60G. Cat / etc/redhat-release and uname-r commands to view the kernel and version, and support linux5/6 2.6.32-xxxxx

  2022-06-01 12:32:00 Views: 238
• 

  Recovery case of Club database based on time point and single table

  Club database based on point-in-time single-table recovery case found problems: DBA found sql injection in club database in 2016-05-20. As shown in the figure below, all the data in the database has been replaced. The specific data is as follows: nickname,realn

  2022-06-01 12:32:00 Views: 289
• 

  Slow website access-high MySQL load (actual combat)

  Today found that the website access is slow, once conducted a survey, began to think confused, the following to sort out the next, fault analysis, first of all, to judge the slow access phenomenon, individual or collective? Personal phenomenon investigation: check personal network, pc, browser, poisoning, etc., do not need to say more about their own Baidu; collective phenomenon investigation: check

  2022-06-01 12:32:00 Views: 206
• 

  Oracle 11g R2 ADG build

  -- = Oracle ADG build =-- = preparation stage = 1. Check that primary is in archivelog mode. Select log

  2022-06-01 12:31:59 Views: 281
• 

  Control file loss, rebuild control file

  Sql > STARTUP NOMOUNTsql > CREATE CONTROLFILE REUSE DATABASE "UNIGUARD" NORESETLOGS NOARCHIVELOGMAXLOGFI

  2022-06-01 12:31:59 Views: 293
• 

  Optimistic lock of database lock

  1. Introduction of optimistic lock optimistic lock is a mechanism to avoid data processing errors caused by database fantasy reading and long business processing time, compared with pessimistic lock, but optimistic lock does not deliberately use the locking mechanism of the database itself, but ensures the correctness of data based on the data itself. Optimistic lock machine

  2022-06-01 12:31:42 Views: 252
• 

  Complete record of MySQL Construction statement to PostgreSQL Construction statement

  Individuals are accustomed to modeling with MySQL workbench EER data, and then generate SQL statements for execution in the database, so that the relationship between tables is more intuitive. Like this: draw a forward project, generate DDL statements: ignore the generation of foreign keys, and foreign key indexes: generated D.

  2022-06-01 12:31:27 Views: 299
• 

  Mysql separates a field

  One field, oldNum, is stored as: "1Magne2, 3pyrr4, 5"; there is also a possibility that "10pd11, 12jpg12, 13, 14", taking only the first few fields. In a situation like this. Consider using the LOCATE () function of mysql at first. But found it to be true

  2022-06-01 12:31:26 Views: 253
• 

  Summary of SQL statements

  No matter in the interview process, or in the future work, SQL will be tested and used. Therefore, some of the SQL knowledge points I have seen before are summarized and recorded, which can be regarded as a notebook. Friends who have not studied SQL deeply and those who are not very impressed with SQL can

  2022-06-01 12:31:26 Views: 261
• 

  The Environment and introduction of plsql: the Construction of the Environment and the brief introduction of plsql

  PLSQL programming 1. Construction of the environment (1) create a storage tablespace SQL > conn / as sysdbaConnected.SQL > create tablespace plsql datafile'/ u01 /

  2022-06-01 12:30:56 Views: 297
• 

  ORACLE RAC11G changes IP address

  Environment: oracle 11.2.0.4 rac modified IP address # public ip192.168.2.71 db1192.168.2.72 db2192.168.2.76 db3#priv ip200.

  2022-06-01 12:30:56 Views: 217