Database Administrator

SQL Server 2014 installation Diagram SQL Server 2014 Enterprise Edition, business intelligence edition, and Standard Edition support the following operating systems: Windows Server 2008, Windows Server 2008 R2, Windows Server 2012, and Windows

SQL Server 2016 improves the Query Optimizer The first two versions of SQL Server mainly improve performance by providing new features, while SQL Server 2016 mainly improves its existing functions. Base Estimator The base estimator is the core of

Redis (4) for beginners-Sort Redis cache and redis Before implementing the cache sorting function, you must first clarify the rationality of this function. Now that you can sort data in the database, why do you need to put the sorting function in

I installed Oracle10g on Win7. Although I have prepared many materials, I still encountered an error. I installed it twice and uninstalled it again, it took nearly four hours to install cancel10g on Win7. In this process, I encountered some problems

SQL Server not found or unable to access server problem solved, Server not found Problem information: "network-related or instance-specific errors occur when you establish a connection with SQL Server. The server is not found or cannot be accessed.

[BUG] Kewastunpackstats (): Bad Magic 1 (0x..., 0), badmagicnumber   Kewastunpackstats (): Bad Magic 1 (0x1108f7b87, 0) In Alert Logfile After Upgrading to 11.2.0.1 Applies to:Oracle Server - Enterprise Edition - Version: 9.2.0.8 and later [

Oracle provides the following explanations for ASCII and CHR functions: ASCII (x) gets the ASCII value of the character X, CHR () and ASCII () have the opposite effect. That is, the ASCII function is used to convert characters into their

Note: Use BTREE to comindex ASC/DESC of each field to optimize order by query efficiency. btreeascThe tbl_direct_pos_201506 table has 1.9 million data, DDL: Create table 'tbl _ direct_pos_201506 '('acq _ ins_code' char (13) not null default

Differences between sys and system users 1) The most important difference is that the importance of stored data is different. Base tables and views of all oracle data dictionaries in sys are stored in sys users. These base tables and views are

To solve the pressure on a single server, the database and sub-server are deployed, but the table data synchronization originally implemented by the trigger cannot be achieved. Because the boss of the Director is not allowed to start the distributed

MySQL Study -- Mysql startup failure "mysql. host", -- mysqlmysql. hostMySQL Study-Mysql startup failure "mysql. host" System Environment: Operating System: RedHat EL55 DB Soft: Mysql 5.6.4-m7 After mysql is installed through the source code

The reason is that the client character set is not set during the export, or the settings are incorrect. It's okay to change it to DB.Check the character set (select userenv ('language ') from dual ;)The exported character set is SIMPLIFIED

Import the Excel table data to the Sqlite database table, and import the data to sqliteImport the Excel table data to Sqlite database table 1. First, prepare the Excel file, open the Excel file, and save it as a *. csv file. 2. You need to create

SQLite tutorial (5): database and transaction, sqlite tutorial I. Attach database: The attach database statement adds another DATABASE file to the current connection. If the file name is ": memory:", we can regard it as a memory DATABASE, and the

PostgreSQL tutorial (8): Index details, postgresql Index I. Index type: PostgreSQL provides multiple index types: B-Tree, Hash, GiST, and GIN. Because they use different algorithms, each index type has a suitable Query type, the create index Command

Mysql data backup and recovery, mysql backup and recoveryBackup/recovery policies:1. Regular mysql backup and recovery time that the system can afford should be taken into consideration.2. Make sure that mysql opens log-bin. With binarylog, mysql

PL/SQL Exception error handling and plsql error handlingZookeeper Exception HandlingA good program should be able to correctly handle all kinds of errors and recover from errors as much as possible. ORACLE provides EXCEPTION and exception handler

[MongoDB] Build a mongodb sharding cluster on the windows platform (2). mongodb Cluster In the previous blog, we talked about the main principles of Mongodb sharding clusters. In this blog, we will mainly describe how to build a sharded cluster.

Newlisp tracks jobtracker status, newlispjobtracker The basic idea is to use newlisp to regularly download the jobtracker page, use regular expressions to parse the table elements in html, and then obtain the latest mapreduce status. Each time the

Mysql SQL Statement Review 2 -- Regular Expressions and mysql Regular Expressions Here, we will briefly review the usage of Regular Expressions in mysql when filtering data. This mainly refers to an example for each usage or a brief description. The