NAV: SLTechnology News&Howtos > Database >

• 

  View temp db

  Use tempdb-- runs every 1 second until the user manually terminates the script to run while 1=1beginselect getdate ()-- tempdb usage dbcc showfilestat at the file level

  2022-06-01 06:47:44 Views: 301
• 

  Optimization of SQL in SQL SERVER

  One of the writing implementations tried in Sqlserver is to scan each current record and merge the next record into the current row. 300000 of the data is very slow, even 30 points, when searching by self-correlation CURR.RN = NEXT.RN + 1 (can find the next one).

  2022-06-01 06:47:44 Views: 285
• 

  Zhong an Visa: a detailed explanation of Guardium database security technology

  Compared with the priority of business and function, the development of security always seems to be one step behind. However, with the penetration of IT infrastructure into various industries, the demand for data security capabilities is becoming more and more urgent, both locally and in the cloud. In recent years, there have been some database security manufacturers in China, such as Zhong'an bit and Ankaike.

  2022-06-01 06:47:44 Views: 285
• 

  Oracle interview Treasure Book-waiting events

  Oracle interview Treasure Book-wait events what is the role of waiting events in Oracle database? First, the origin of the waiting event leads to the introduction of the waiting event because of the development of the index system. To sum up, the index system of Oracle has roughly experienced the following three

  2022-06-01 06:47:40 Views: 302
• 

  Storage engine and log description of MySQL

  MySQL Storage engine and Log description 1.1 introduction to the storage engine 1.1.1 File system Storage File system: a mechanism by which the operating system organizes and accesses data. File system is a kind of software. Type: ext2 3 4, xfs data. No matter what file system is used

  2022-06-01 06:47:10 Views: 278
• 

  ORA-00843,ORA-00849 When Trying To Change SGA_TARGET With MEMORY_MAX_TARGET=0

  ORA-00843, ORA-00849 When Trying To Change SGA_TARGET With MEMORY_MAX_TARGET=0 Being Active (document ID 1

  2022-06-01 06:47:09 Views: 238
• 

  MySQL 5.5 commonly used replication environment management commands

  1. Check the status of the Slave node to show the important parameters of the slave thread. Mysql > show slave status\ gateway * 1. Row *

  2022-06-01 06:47:06 Views: 209
• 

  Check connection related issue of mysql

  Check connection issue of mysql#show connection configurationshow variables like'% max_connection%'

  2022-06-01 06:47:06 Views: 203
• 

  A hole-filling weapon? How to make up for the deficiency of traditional MySQL Architecture by Redis

  For technical people, one of the most successful aspects of Redis is its ability to supplement and expand other databases in the ecosystem. Although replacing the old back-end database with a new back-end database is often considered risky and expensive, it may be difficult for the original database to scale linearly to meet the needs of the

  2022-06-01 06:47:06 Views: 277
• 

  Page structure of PostgreSQL Storage engine

  The following figure is the structure diagram of page. The 8K space includes a header Page Header, several Item, each Item pointing to a record (Tuple). Some Page, when initializing, reserve space as Specia at the end of the page.

  2022-06-01 06:47:05 Views: 234
• 

  Weird "slow inquiry"

  I received a notice from R & D in the morning that there were a large number of slow queries in the database, and sent the call time, the query time is basically more than 0.5s. Tell them to send sql, open the database connection, execute sql, and find that sql execution is very fast, and the execution time is less than 0.1s. Let them check.

  2022-06-01 06:47:00 Views: 255
• 

  Oracle string

  -shell---sqlplus--sql10-empno single-line function-processes every row in the table, and each row has a return value numeric function, character function, date function, multiline (aggregation) function--

  2022-06-01 06:46:57 Views: 252
• 

  Register static snooping (Register static listener)

  1. First go to the $ORACLE_HOME/network/admin directory and modify listener.orago to $ORACLE_HOME/network/admin, edit listene

  2022-06-01 06:46:57 Views: 259
• 

  Kettle:Oracle multi-form batch synchronization data = "mysql

  Oracle multi-form batch synchronization data = "MYSQL scenario multiple Oracle tables, automatically synchronize data to mysql through polling. Avoid each Oracle table data = "mysql makes a transformation, resulting in a large number of transformations, which are difficult to manage and adjust." Mainly through

  2022-06-01 06:46:49 Views: 277
• 

  The OLE DB provider of the linked server reported an error. The provider terminated execution because the resource limit was reached.

  Exception .sysno: = 1586 exception content: System.Data.SqlClient.SqlException (0x80131904): OLE DB provider "SQLNCLI11" of the linked server "data"

  2022-06-01 06:46:49 Views: 261
• 

  MySQL's purchase of InnoDB is defeated by Oracle announces the opening of data engine (transfer)

  MySQL was defeated by Oracle to announce the opening of data engine [@ more@] 08:32 on April 28, 2006 eNet Silicon Valley Power [eNet Silicon Valley Power News] according to foreign media reports, Oracle acquired the data engine used by MySQL.

  2022-06-01 06:46:49 Views: 256
• 

  Turn off the autocommit function of MySQL under Windows

  With the increasing application of MySQL, InnoDB, which supports transaction, has become the default storage engine of MySQL. Unlike many relational databases, in the InnoDB storage engine, transactions commit automatically by default, that is, every DML statement triggers com

  2022-06-01 06:46:48 Views: 274
• 

  The construction of OneProxy sub-database and sub-table

  Experimental environment: circular replication master1:192.168.8.57master2:192.168.8.58master3:192.168.8.59oneproxy:192.168.8.63 of three nodes prepared in the previous stage

  2022-06-01 06:46:48 Views: 264
• 

  Practical information | how does Ali make his dream of "capacity expansion before peak and capacity reduction after peak" come true?

  Double 11 has come to a successful conclusion, but the exploration of technology has not stopped. "Alibaba Database Technology" hereby launches a series of practical information articles entitled "winning the War 2018 Shuang 11 Mutual-Ali Database & Storage Technology uncover Secrets" to tell you the story behind the super number 213.5 billion. Please pay attention! Introduction:

  2022-06-01 06:46:38 Views: 236
• 

  How to modify the appearance style of fractions in PPT? Explain the simple steps

  When we are making PPT, we want to modify the appearance style of the scores in PPT, how to operate it easily? Here are some ways to share with you today. Let's take a look. There are three types of scores inserted in PPT: vertical, skewed, and horizontal. You can cut between the three styles according to your needs.

  2022-06-01 06:46:33 Views: 264