Database Administrator

Editor's note: I shared with us a lot of things about his practice of SQL Server. What will I share with us this time? Please look forward... Today I found a very interesting phenomenon. The company's computer will prompt you to reset the logon

IN Operator SQL statements written IN are easy to write and understand, which is suitable for modern software development. However, SQL statements using IN always have low performance. The following differences exist between SQL statements using IN

Introduction The DB2 agent is a process or thread located on the DB2 server that serves application requests. When an external application connects to a DB2 instance to request access, the DB2 proxy is activated to respond to these requests.

The analysis functions in ORACLE divide computing Windows based on several fields, and then aggregate, rank, and so on in the window. I think if the hash partition field of our data table is consistent with the partition by field in the analysis

Here we will compare the difference between ms SQL Server and Oracle Database Transaction processing, hoping that the comparison will help you better understand the original appearance of transaction processing. Background Software Programming in

Here we will introduce the installation of Oracle RAC in Linux. Oracle Real Application Server, Real Application cluster, Oracle RAC for short, is an Oracle Parallel cluster, oracle instances in Different server systems access the same Oracle

Let's talk about database issues. I have seen several statements on the Internet. Let's take a look at whether they are correct or not, and whether they are ambiguous or misleading. 1. or may cause a full table scan. 2. in may cause a full table

Here we will discuss the MySQL database authorization principle, which also concerns the security of the majority of small and medium-sized enterprises databases. MySQL is a cross-platform open-source relational database management system. It is the

I have been thinking about the following question recently:How to Create a performance model for a database? As a DBA, we are faced with a huge challenge: how to ensure that the database performance can meet the needs of rapidly changing

This article first discusses the basic design of database tables based on the third paradigm, and focuses on the strategies and solutions for establishing primary keys and indexes, then, the optimization solution of the database management system is

BKJIA exclusive Article]In the previous article on MySQL database optimization, we followed the author to learn about the optimization of the single-host MySQL database. Today we continue to follow the author's learning about the MySQL Optimized

Editor's note: In this article, the author describes a process of promoting the Access database to the SQL database and migrating it back to the Access database. In addition, the author briefly describes the migration process, what problems have my

If you have a one-to-many relationship and want to Join two tables, but you only want to generate a row in each "one-to-many" relationship, you can refer to the following: A simple example is as follows: If you want to obtain the essay ID, Title,

Introduction: Remote database managementAs one of the hottest trends in the database market, remote database management is a service provided by a third-party company-within the scope of compliance with established rules, A third-party company

Yesterday, when a friend used Repeater to bind a data source, it always showed that "the attempt to call FieldCount when the reader is disabled is invalid. "Error. I read his code and used the ExecuteReader method under the SqlHelper class to return

I have seen some posts: questions about DataReader's closure, which may seem confusing to everyone. I will explain it here: No matter what xxDataReader is, It inherits the implementation of DataReader, so there are commonalities, so the title is

There are a lot of articles on Database optimization, but some of them seem to be incorrect and some are impractical. For a single database, they can only be better, not the most optimal, and because of different actual needs, there are still some

When I was just finishing my next shift, I sat down bored in the company. A colleague gave me some data and told me to implement a statistical report similar to a cross table. I thought it would take up to ten minutes to get it done. I did not

Today, database operations are increasingly becoming the performance bottleneck of the entire application, especially for Web applications. Concerning the database performance, this is not just something that DBAs need to worry about, but it is

Some time ago, ** the DBA of the company came to our training. I talked about a lot of MYSQL optimizations. QA Stage 1: the programmer asked: "Can the with nolock in SQL statements read other locked data except for non-locked tables" The lecturer