SQL Server

Original: Find SQL Server database history growth informationMost of the time, when we plan the space for a SQL Server database, or space for storage, we need to estimate the size of the required database space, and the simplest way to estimate the

Original: SQL Server 2005 database scheduled replication for dual standby (primarily SharePoint content databases)SceneThe company's most recent database server for SharePoint is always in trouble, and is not working properly once a problem occurs.

Condition analysisThe environment is as follows:Hardware: IBM3610 ServerSystem: Windows2003 x32Application: Internal logistics System software C/s architectureDatabase: SQL Server2000Problem: Because the Logistics system architecture

When the database is larger, and we want to make a backup, we can start the compression of the database backup, thus reducing the consumption of disk space.In fact, not only can be compressed at the time of backup, in SQL Server 2008, we can also

In the design of the database, often do not take into account the problem of table partitioning, often in the burden of the data table load is getting heavier, will take into account the partitioning method, at this time, it is related to how to

is an important table detailing the backup requirements of the system database, the recovery model supported, and the options for restore.master database: requires backup and needs to be restored in single-user modemodel database: need to be backed

MVCC snapshot Isolation level for SQL ServerMVCCProduct Introduction edit Multi-version Concurrency Control multiple versioning concurrency controls most MySQL transactional storage engines, such as Innodb,falcon and PBXT, do not use a simple

Code:if object_id (' Sp_inputaccesstosql ')  is not null    drop proc  sp_inputaccesstosqlgocreate proc sp_inputaccesstosql@dir nvarchar,--The path to the Access file: such as D : \files@tabname nvarchar ( --) defines the name of the table that is

1. Create a test databaseCreate DATABASE ServerbrokertestOn Primary (Name=serverbrokertest_data,Filename= ' C:\Program Files\Microsoft SQL Server\mssql11. Sqlexpress\mssql\data\serverbrokertest_data.mdf ',Size=5,Maxsize=unlimited,Filegrowth=1)Log on(

In general, SET ROWCOUNT is used in statements to make subsequent queries, updates, and deletions affect only the specified number of rowsFor example, execute the following statement togetherSET ROWCOUNT 1SELECT * from sysobjectsThe result returns

Understanding Transactions and LocksTransactions: The essential tool for maintaining logical data consistency and recoverability.Lock: When multiple users access the same database resource, a mechanism for the priority authority management of access,

Sometimes the database is occupied, want to do some operations, unable to operate. You can try to switch the database to single-user mode to operate. Switch back to multi-user mode after the operation is complete.The command is as follows:ALTER

Original: Replication under multiple instances of SQL ServerI. What is covered in this article (Contents) What is covered in this article (Contents) Background (contexts) Build Step (Procedure) Precautions (Attention) two.

Determine the installed SQL Server 2000 Database Components version Use isql, osql, or query analyzer to Perform one of the following queries on Database Engine instances. Select serverproperty ('productlevel ') SELECT @ VERSION Select

Stored Procedures in Transact-SQL are very similar to methods in Java. They can be called repeatedly. After the stored procedure is executed once, you can cache the statements so that the statements in the cache are directly used for the next

When writing SQL statements, some statement aliases cannot be called. Baidu's reasons are due to different alias mechanisms. In order to avoid making the same mistake again next time, I summarized the information found on the Internet. The execution

The interconnection of different database platforms is generally called the heterogeneous service of databases. Currently, all major databases can achieve such Heterogeneous Interconnection, but the specific implementation technologies of different

Main Category Table Name: Navtion_TopSubject primary key fTopID Char (36)Sub-category table name: the foreign key of Navtion_NodeSubject is the sameContent table name: The tText foreign key is the same as aboveCopy codeThe Code is as follows:// -----

However, Microsoft SQL server has an important defect in processing such indexes, that is, the operations that should have been compiled into index seek are compiled into index scanning, which may cause serious performance degradation.For example,

In SQL ServerEach database has a table generated by the system.The table sysobjects records all the table names in the database.We can use the following SQL syntax for query operations. Copy codeThe Code is as follows:Select Name, id from