NAV: SLTechnology News&Howtos > Database >

• 

  SQLServer file type

  SQLServer database file type database is stored on disk in units of files and consists of data files and transaction log files. A database should contain at least one data file and one transaction log file. The database is created on a NTFS partition on physical media, such as a hard disk, or

  2022-06-01 12:13:21 Views: 256
• 

  About the pit of replicate_do_db and replicate_ignore_db

  Introduction to MySQL5.7 official documentation introduction to related parameters: https://dev.mysql.com/doc/refman/5.7/en/change-replication-filter.html in version 5.7

  2022-06-01 12:13:21 Views: 233
• 

  Create a stored procedure

  Use TESTgocreate PROCEDURE [dbo]. [SP_ material in and out cycle] (@ start date VARCHAR (8), @ end date VARCHAR (8) @ id char (

  2022-06-01 12:13:20 Views: 280
• 

  Storage location of ODBC clinet

  2052_chs_lp\ x64\ setup\ x64 extract sqlcli.exe of CD

  2022-06-01 12:13:17 Views: 255
• 

  Oracle Database 12c DBA Civil Service Manual (8th Edition)-Chapter 12 Real-time Application Cluster

  The PDF eBook free download address http://www.allitebooks.com/oracle-database-12c-dba-handbook/1 Overview RAC database is highly available and extensible. Every node must have

  2022-06-01 12:12:59 Views: 256
• 

  Skype For Business 2015 practical series 6: install CU6 patch for back-end database

  Skype For Business 2015 practical series 6: install CU6 patch for back-end database after installing SQL Server 2014, you need to install CU6 patch for it to meet Skype For Business Serve

  2022-06-01 12:12:59 Views: 296
• 

  Linux system Oracle Temp01.dbf is getting bigger and bigger. It should be solved like this.

  When Oracle is installed on the centos system, the disk space of the system itself is not very large. After running for a period of time, it is found that the temporary table space of Oracle takes up more and more disk space, so that the system is on the verge of crashing. The solution to this problem is as follows: step 1: alter data

  2022-06-01 12:12:59 Views: 289
• 

  Install oracle Instant client

  First, the requirements database and the application are not on the same host, so you need to install the oracle instant client, which can also be the client of oracle. It's just that the client is huge. Install oracle real-time client to download Oracle real-time client package http:/

  2022-06-01 12:12:49 Views: 218
• 

  Installation of MySQL 5.6.35 RPM package

  Mysql version 5.6.35 RPM package installation. Delete the old RPM package: query rpm-qa | grep-I mysql delete rpm-ev mysql-libs- nodepsrpm if necessary

  2022-06-01 12:12:49 Views: 243
• 

  Do it yourself, talk about the fastest way to remove duplicate records from MySQL database

  Mysql database repeatedly inserted some data, wanted to delete and retain one, looked for a lot of solutions, such as this and this kind of first try, feel that the effect may be achieved, but the speed is too slow, dozens of hundreds of data, dozens of millions, the mysql.exe process is basically

  2022-06-01 12:12:49 Views: 291
• 

  [Oracle Database] Oracle GoldenGate (single-single)

  Source database configuration [root@king01 ~] # su-oracle [oracle@king01 ~] $sqlplus / as sysdbaSQL > create tablespace gold

  2022-06-01 12:12:49 Views: 211
• 

  Shell checks whether the mongodb port exists

  #! / bin/bash port= "27017" start= "nohup / usr/bin/mongod-- config / etc/mongod.conf &" EMAIL= "/ bin/echo m

  2022-06-01 12:12:48 Views: 256
• 

  Mysql Series 6-use a third-party tool-percona to back up mysql and restore

  Use third-party tools to back up mysql-percona 1. Preliminary preparation: 1. Install dependency package: yum-y install perl-Digest-MD5 perl-DBD-MySQLrpm-ivh li

  2022-06-01 12:12:48 Views: 260
• 

  One-click automated deployment (customized rpm package)

  Deployment-MySQL multi-instance deployment was completed in the previous morning. Due to some specific requirements of the company, source code installation is required, and now batch deployment is required. If you deploy one by one, it will be too troublesome and a waste of time. At this time, automated deployment shows the value of customizing MySQL production.

  2022-06-01 12:12:42 Views: 220
• 

  Oracle starts archiving

  Oracle sets the archiving mode to see if archiving is enabled. Open the archive and set the archive path:

  2022-06-01 12:12:36 Views: 203
• 

  Centos6.8 64-bit Discuz runtime environment

  Linux CentOS compiles and installs LNMP environment + discuz + phpmyadmin products constitute the full version of Discuz-3.3 UTF8 Nginx-1.6.3Php-5.5.38Mysql-5.5.20P

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

  Pxc- Readiness and recovery

  Full backup command sudo mysqldump-usunx-pause mysqladmin'- P6612-h292.168.1.203-A-B-- skip-add-locks-- skip-lock

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

  How to monitor mongoDB?

  Use mongostat to view the company's database status mongostat-host IPADDRESS:27020-username root-password PASSWORD-authenti

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

  ORA-12547: the processing method of TNS:lost contact error report

  In the last two days, Oracle 12.2 has been installed on the virtual machine, and the installation process is quite smooth. However, the database cannot be connected after the virtual machine is restarted. Execute sqlplus / as sysdba to report an error ORA-12547: TNS:lost conta

  2022-06-01 12:12:26 Views: 279
• 

  Msi for SQL Server2005 Enterprise Manager cannot be installed directly

  After the installation of SQL Server2005 Enterprise Edition or Development Edition is complete, you may find that there is a lack of enterprise manager for database management because of conflicts caused by other MicroSoft development tools installed on your computer. Search and download SQL on the Internet

  2022-06-01 12:12:22 Views: 287