SQL Server

Introduction SQL Server 2008 introduces CDC (Change Data Capture), which can record:1. What data lines have changed2. The history of data row changes, not just the final value.It implements asynchronous change tracking (like transactional

Original: SQL Server 2012 alwayson--Specifies a data synchronization link to eliminate commit latency issues caused by network jitterEvent Cause: Recent research and development reaction, a database from 08 to 12 environment, the occurrence of write

Anatomy of the SQL Server kernel Architecture (reproduced)This article in my computer for a long time, today careless to turn out, think write very good, so posted out to share.Have to admit that a good software is a step-by-step accumulation of

Comparison of several scenarios for high availability in SQL Server 2012, where AlwaysOn advantage is compared to several scenarios for SQL Server 2012 high availability and disaster recovery, replication, clustering, mirroring, what are the

Approximate steps:A. Create an auditB. to create a database-level audit specification - creation, deletion and modification of monitoring database objectsC. Test Auditing features - Create, modify, and delete database objectsD. Use the log file

This article describes how the query memory grant, which works on SQL Server, applies to SQL 2005 through 2008. Query Memory Grants (hereinafter abbreviated as QMG) are used to store temporary intermediate data rows when data is sorted and

This article is a series of articles in the fourth and the last, this article requires the first three articles of knowledge as the basis, the first three articles address as follows:On transaction log in SQL Server (i)----the physical and logical

1. Basic phenomenon: The MSSQLServer service cannot be started, and a 17051 error is reported by manual start.2. Workaround:First step: Enter the installation center in the SQL2008 Configuration tool,Second step: Re-enter the maintenance interface,

The following series of official training courseware for SQL Server 2014 has been released.The required MCT (Microsoft Certified Instructor) can download these courseware by logging in to the official HTTPS://MOCL.ONE.MICROSOFT.COM/CWDL

IntroductionEncryption refers to the process of blurring data by using a key or a password. In SQL Server, encryption does not replace other security settings, such as preventing unauthorized people from accessing the database or the Windows system

Brief introductionIn SQL Server, each query will find the shortest path to achieve its own goal. If the database accepts only one connection at a time, only one query is executed. Then the query is, of course, M.F.B. s to complete the work. For most

Microsoft SQL Server Internals Index directory:"Microsoft SQL Server Internals" Reading notes-Catalog IndexIn the fifth chapter, we mainly study the internal storage structure of table, and the seventh chapter "Special storage" will continue to

first, the basic principlePlease check this URL, speak Gray often detailed: http://www.jeffkit.info/2010/01/476/Ii. steps of Implementation 1 . Install drivers for SQL Server under Linuxinstall FreeTDS, do not use the Apt-get install, because the

during the implementation of the XENDESKTOP5 project, it was found that the XENDESKTOP5 version of the database mirroring transaction log was large, in XENDESKTOP4 and The problem does not exist in the XENAPP version, so I'm going to

Original: MS SQL Server2014 link MS SQL Server 2000In development and enterprise applications, several versions of SQL Server are linked to each other. Distributed reading and storage requires implementation of sp_addlinkedserver. SQL Server, SQL

For beginners, the writing of T-SQL statements has always been a problem, and beginners are accustomed to using the graphical interface to do related SQL maintenance work. But in a slightly more complex and large SQL scenario, if we can quickly

A stored procedure in Transact-SQL, very similar to a method in the Java language, can be called repeatedly. After the stored procedure executes once, the statement can be cached so that the statements in the cache are used directly at the next

Transferred from: http://blog.csdn.net/esrichinacd/article/details/85102241 overviewThe installation configuration for ArcSDE 10.1 has some notable changes compared to ARCSDE 10.0 and earlier, such as canceling the Post Install Wizard, and many of

SQL server imports access data with a password How to import Access data to SQL Server? I believe there are many tutorials on the network to help you. However, if the access document uses password encryption, you will find that the methods described

Solve the problem that the sa account of each SQL Server Version cannot be logged on. sqlserversa 1. use Management Studio Express, log on with "Windows Authentication", select the SQL server name, right-click and select properties, and select