SQL Server

"Create using local Distributor"/************************ "Publishing with local distributor configuration" ***********************/--sqlserver r2--https:// technet.microsoft.com/zh-cn/library/ms151860 (v=sql.105). Aspxuse mastergo--The Distributor

Original: View history of SQL Server Agent jobsNot to say well-known, but most people should know that SQL Server Agent operations are stored in the SQLSERVER5 large system database (master/msdb/model/tempdb/resources) in msdb, Because of the

IntroductionSQL 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 replication)

What is a self-increment columnThe ID column can be set to self-increment in SQL Server. That is, you do not need to specify a value for the ID, the column is automatically assigned a value by SQL Server, and the value of each new column ID is added

SQL Server Monitoring (monitoring) ArchitectureIn daily management of SQL Server, having SQL Server run efficiently and with good performance is what DBAs need to do. DBAs need to understand the daily performance, analyze and tune performance, and

Enable AD Hoc distributed Queries: ' Show advanced Options ', 1 Reconfigure ' Ad Hoc distributed Queries ', 1 Reconfigure When you are finished using, close ad Hoc distributed Queries:' Ad Hoc distributed Queries ', 0 Reconfigure ' Show

Ext.: http://blog.csdn.net/jackychu/article/details/4183118Http://www.cnblogs.com/jhxk/articles/1633578.htmlMany developers in the database design often do not have much to consider char, varchar type, some do not pay attention to, because the

CREATE PROCEDURE YourprocedureAsBEGINSET NOCOUNT on;Begin TRY---------------------Start catching exceptionsBEIN TRAN------------------Start a transactionUPDATE A SET a.names = b.names from table 1 as A INNER JOIN table 2 as B on a.id = b.IDUPDATE A

An identity column in SqlServer2012 has an attribute:When the server restarts, the identity column defined as int automatically adds 1000 to the original maximum value. For example, your original self-increment column of the maximum value is 2, then

Microsoft has introduced many highly available technologies for SQL Server, such as early replication, later log shipping, database mirroring, SQL Server clustering, and so on. In SQL Server 2012 There is also a killer, and Oracle has a fight! SQL

NOLOCK (without lock)When this option is selected, SQL Server does not add any locks when reading or modifying data. In this case, it is possible for the user to read the data in the incomplete transaction (uncommited Transaction) or rollback (roll

Original: SQL Server 2012 autogrow column, value hopping problemIntroducedStarting with the SQL Server 2012 version, when the SQL Server instance restarts, the values for the autogrow column of the table will jump, and the size of the specific hop

Database mirroring is a software-based solution for database high availability. It maintains two identical copies of a database, each of which is placed in a different instance of the SQL Server databaseOverviewDatabase mirroring is a software-based

The problems encountered in the work, in order to maintain the projects that others do, need to know the unfamiliar project database, often the data storage table naming can not be named to guess the meaning of the table, it seems more laborious,

Reprinted from: http://www.lmwlove.com/ac/ID943Usage of ROWCOUNT:The function of rowcount is to restrict the subsequent SQL to stop processing after returning the specified number of rows, such as the following example,SET ROWCOUNT 10SELECT * FROM

first, the concept of bookmark searchBookmarks can help SQL Server quickly direct from the nonclustered index entry to the corresponding line, but I can actually say a few words about it.　　If the table has a clustered index (the section structure),

Planning Cache (plan caches)If SQL Server has found a good way to execute a piece of code, it should be reused as a subsequent request because Generating execution plans is time-consuming and resource-intensive, There is a point in doing so. If the

Background I have a virtual machine that wants to connect to SQL Server, but does not want to install SQL Server.Solution SQL Server has a dedicated access client called SQL Server native client, and a command line connection program sqlcmd, in

Introduction On Windows, SQL Server OS is a user-level operating system level used to serve SQL Server. It abstracts some functions of the operating system from the entire SQL Server engine and forms a separate layer to provide services for the

Example of deleting duplicate records in a data table in SQL Server, SQL Server [Project] The users table in the database contains the u_name and u_pwd fields. The u_name contains duplicate items. Now we need to delete duplicate items! [Analysis] 1.