Database Administrator

SQL Server 2016-locally compiled Functions The native compiled stored procedure is introduced in SQL Server 2014, and in SQL Server 2016, we will be able to implement a Scalar User-Defined Function (Scalar UDF) natively Compilation ). SQL Sever

PostgreSQL transaction model Introduction PostgreSQL has its own transaction implementation model. There are three layers: top layer, middle layer, and bottom layer. 1. Top Layer The Top Layer is mainly controlled by users and visible to users. This

HBase cannot connect to ZooKeeper. hbase connects to zookeeper. The following error is reported when you log on to the server after setting up the HBase Environment last time: Hadoop @ gpmaster logs] $ hbase shellSLF4J: Class path contains multiple

Improvements to the Hive Optimizer, improvementshive LanguageManual JoinOptimization Improvementsto the Hive Optimizer Hive can be automatically optimized, and some optimization cases are improved in Hive 0.11. 1. The JOIN side is suitable for

Create view reports ORA-01031: insufficient privileges, insufficient Create view reported ORA-01031: insufficient privileges Create a script for the required experiment environment: create user lc0019999 identified by aaaaaa;create user lc0029999

Connect to the MySQL database using JDBC-Typical Case Analysis (7)-insert employee information in batches, jdbcmysql Reprinted Please note:Zhang Qi's CSDN blog-blog channel-CSDN. NET Problem: Insert 100 pieces of data into the Emp table in batches.

MySQL is sorted by Chinese characters and Pinyin letters, and mysql is sorted by Chinese Characters If the MySQL encoding format is GBK character set, you can add Order by name asc; -- sort in ascending order If the utf8 character set is used,

Solve MySQL programming on linux (1): Install MySQL and linuxmysql on the linux source code[Copyright statement: respect originality. For reprinted content, Please retain the Source: blog.csdn.net/shallnet. this document is only intended for study

JDBC connection pool with the best performance: HikariCP, jdbchikaricp HikariCP claims to be the best-performing JDBC connection pool component. I have not carefully tested the specific performance, but from the perspective of its development, it

Difference between count (*) and count (field name) in SQLThis article uses examples to describe the differences between count (*) and count (field name) in SQL. For details, refer to examples. I did not pay attention to the difference between the

Detailed configuration and deployment of SQLServer replication and database images, detailed configuration of sqlserver SQLserver can deploy images and copies at the same time, and combine the high availability of both parties to ensure better

MySQL updates Chinese columns: 1366 Incorrect string value solution, 1366 incorrect Environment: mysql-5.6.25-winx64, MySQL workbench Problem: An exception occurred during MySQL update: Warning (s): 1366 Incorrect string value: '\ xE8 \ x82 \ x96

Data cleansing Note: When multiple users call the same function, note that multiple users Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. You must specify the source when you repost them. Otherwise, you have the

Many database data processing stories and database data processing stories Every year, you will encounter a series of data import problems. I learned a lot from it. In the past two days, I have been asked why you are always importing data. There is

Database Paradigm (normal form NF), normalnf 1. Currently, there are six paradigms: 1NF, 2NF, 3NF, BCNF (base-cod paradigm), 4NF, and 5NF (perfect paradigm ). 2. Various paradigms are progressive, backward compatible, that is, to meet the second

Troubleshooting of online MySql connection exceptions As a common database, Mysql is widely used in Internet systems. Some faults are their own bugs, and some are not. Here are examples of problems encountered in the past.Problem The problem was

Windows operating system (no matter 32bit or 64bit) does not support the db_32k_cache_size parameter of oracle db ., 32bit64bit differences The db_32k_cache_size parameter of oracle db is not supported in Windows (no matter 32bit or 64bit. As

SQL and SQL tutorials At last, I had time to continue playing the Alibaba Data Mining competition. I had to refresh the database with the limited tools for the second season. The following notes are summarized from the Web tutorial.SQL Introduction

SQL Study Notes (5) --------- Time query statements and Study NotesMySQL NOW () function definition and usage The NOW () function returns the current date and time.Example 1 The SELECT statement is as follows: SELECT NOW(),CURDATE(),CURTIME() The

Data Center reconstruction-SqlHelper application and data center reconstruction-sqlhelper Since the implementation of each function in the data center reconstruction process involves database link access, the Code repetition rate is very high, which