sql server

What is a MySQL database? Typically, a database is a collection of data, and a database can be a collection of files on a memory or a collection of some memory data. We usually say that the MySQL database, SQL Server database, etc. is actually a

The "IT168 Technology" cursor (cursor) is a data buffer that is opened by the system to the user and holds the execution result of the SQL statement. Each cursor area has a name. The user can use SQL statements to retrieve records from the cursor

The following article mainly introduces the SQL server database and its actual application metadata, I saw the SQL server database on the related website two days ago Rather than actually applying the metadata data, it feels good to share it with

SQL Server has powerful replication capabilities, in addition to synchronizing data and database objects from one database to another and accurately distributing them. SQL Server replication is divided into three kinds, the following describes the

Today, my classmate asked me a question, I think it is very interesting, now recorded down to discuss. The problem is: in a table, there is a field that is allowed to be empty, and null can be repeated, but a value that is not NULL needs to be

The MSSQL SERVER2000 Security Configuration removes the SQL procedure with security issues. More comprehensive. Everything for safety! Delete the call shell, registry, COM component's corrupted permissions MSSQL SERVER2000 Security Configuration

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 may not be very powerful, but because it is open source, widely spread, so many people are aware of this database. In today's world is a very popular open source database, some people say that MySQL is completely free software, this is not

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

Authoritative Test organization TPC United States December 3 confirmed that Oracle company submitted the previous day SPARC T3-4 supercluster to TMPC (the number of transactions per minute) 30 249 688 created a new record of tpc-c performance

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

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