sql

The following articles are mainly about the 4 magical uses of SQL Server Data Transformation Services to perform some automated operations. In the actual operations management of the SQL Server database , the database administrator wants the

MySQL replication is quite complex compared to the replication of NoSQL databases such as MongoDB,redis ! Overview The primary server first logs data changes to the primary log, then reads the master log on the primary server through the I/O

First of all we need to know that there may be a number of reasons why we can choose to use it, but let us not use it often as long as there is a reason is enough. The same is true for choosing a software PRODUCT. MySQL Database Although the

The potential central premise of extreme programming is that two ideas are better than one. Two programmers sit side-by-step, one programming, the other a block by line. The reason for this is obvious, if the person who operates on the keyboard is

Compressed, encrypted, and hardened MS SQL Server Backup Ø Create a sound backup--use network restore and other features to reinforce your backup Ø save time and space-compressed database backup up to 95% Ø protect data-using up to 256-bit AES

As early as 08, as Microsoft launched Windows Server 2008 and Visual Studio 2008, another member of Microsoft's next-generation server product front, SQL Server 2008, was also officially released. It can be said that SQL Server 2008 in the database

　　1. Data and log files are stored separately on different disks The operation of data files and log files produces a large amount of I/O. Where possible, the log file should be stored on a hard disk that is different from the data file where the

The following article mainly describes the SQL Server cursor instance, if you encounter a SQL Server cursor instance in the actual operation, but you do not know how to apply correctly to it, then the following article to you must be a mentor, hope

Small series used to do in ASP and. NET is often used in SQL SERVER, now use PHP although most of the time with MySQL, but does not pan some customers in the original SQL platform to upgrade or compatible development, it is fortunate that PHP is

Recently encountered the "SQL How to link remote MySQL" Problem, now the problem is finally resolved, special methods posted: (I used the operating system is Win7, the database is SQL2005.) ) 1, install the MySQL ODBC driver on the SQL Server

SQL Server temp tables are often needed, and here's how you can use SQL Server temp tables to troubleshoot problems that prevent users from recurring logins for your information. When we develop business software, we often encounter the question of

SQL stored procedures are widely used in SQL databases, and here is how to define SQL stored procedures, and if you are a user who has just contacted a SQL database, you may want to look at it to help you learn about SQL stored procedures.

A few days ago also encountered a large log file problem, the actual size of the database is 600M, the actual size of the log file is 33M, but the log files occupy a space of 2.8G!!! Try a variety of ways, Shirnk DATABASE, TRUNCATE LOG file, there

SQL Server and Oracle these two databases, in addition to some technical differences, in the implementation costs are also relatively large differences. The following author on this aspect of content to express some of their views, I hope to be able

One, the importance of indexing Indexes are used to quickly find rows that have a specific value in a column. Without indexing, MySQL must start with the 1th record and read through the entire table until the relevant rows are found. The larger the

Navicat is a powerful MySQL database management and development tool. NAVICAT provides professional developers with a powerful enough cutting-edge tool, but it is still easy to learn for new users. The new features of Navicat 9.0.15 include: -Form

Class if there is a reply form for a post, posts (ID, TID, subject, message, Dateline), ID for the automatic growth field, Tid for the reply to the topic of the ID (Foreign key Association), subject for reply to the title, message for the reply,

In real life, backing up the database on a regular basis is an extremely important task. When we use MySQL, there is a lot of choice in database backup, and this article will show readers how to use MySQL's mysqldump to back up the database. First,

In the second edition of the high performance MySQL, the time comparison between the SQL file and the definition character file in the backup and restore was seen.Method file size Export time restore timeSQL Dump 727M 102s 600sDelimited dump 669M

The MySQL database is an open source database based on structured data. The SQL statement is the core language in the MySQL database. However, in the MySQL database to execute SQL statements, you need to be careful two traps. Trap one: null value