SQL Server

Requirements DescriptionGenerally in the production environment, sometimes need to automatically detect the status of the indicator value, if there is an exception, need early warning, such as e-mail notification, this article is introduced if the

In-memory database, which refers to the direct manipulation of database data in memory. Compared to the storage on the disk, memory data read and write speed is much higher, so it can improve the performance of the application. Microsoft's SQL

Introduction Change tracking is a lightweight solution that provides an efficient change-tracking mechanism for your application. Regular, custom change tracking and read tracking data, which uses triggers, stored procedures, and user tables that

Original: SQL Server R2 Performance counter detailed list (i)SQL Server Backup Device counters:Can monitor the Microsoft SQL Server backup device for backup and restore operations SQL Server Backup Device counters

When the project was recently expanded, the problem was to convert the integral type to a specified length of 16 binaryAt first it was the direct use of cast (varbinary (4)) but finding out this doesn't solve my problem.So I searched the Internet,

Reprinted from Microsoft official documentation http://msdn2.microsoft.com/zh-cn/library/ms378995.aspxIncluded in Www.enjoyjava.net/f25This article is longer and contains the following sections Using stored procedures with no parameters

　　Originally wanted to write something about this series, and then think of everyone as a programmer, the most used is the database, but in fact a lot like me to work in the first line of the code farm, on the SQLAll smattering, don't talk about

1. Server type When we select the database engine, the login username is not found, the server name below is only displayed as "(local)", and even "Windows Authentication" cannot log on.If my friends and I have the same problem, please take a look

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,

RT, failed to execute, always only prompt a "to XXXX user identity execution Failure", it is difficult to find the reason. Reference http://bbs.csdn.net/topics/300059148Sql2005 How to run SSIS (DTS) packages with dtexecfirst, in Business

In developing T-SQL, it is often necessary to perform a variety of operations on strings, and the following describes commonly used string functions.　　1. ASCII ASCII code to get charactersThe ASCII code is the standard encoding of the character. To

Since what is currently done is a simple class of database operations, it involves the following query statements, which are recorded here.1. Query table nameselect object_id,namenamefrom sys.tables2. Querying column informationSELECT( Case

We all know that when you need more than 2 columns in a table to determine the uniqueness of a record, you need to use the federated primary key, and when the Federated primary Key is established, the performance will be greatly improved when

Today I want to talk about a particular problem that I will encounter every time I talk about lock and block (Locking & Blocking) in SQL Server: Why do we need to update the lock in SQL Server? Before we explain the reasons for the specific needs,

A transactional publication was created and an error occurred during initialization to view the relevant proxy information as follows:Log Reader Agent error:Status: 0, Code: 20015, Text: ' Remote server ' serverName ' does not exist, is not

The plus n prefix specifies that the following string is a Unicode constant, and the SQL ServerUnicodeData types are SQL-based- theThe national character data type in the standard. Sql- theuse the prefix character N to identify these data types and

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/6E/2B/wKioL1V1oJmiioKJAAJGScTltts402.jpg "style=" float: none; "title=" 96.png "alt=" Wkiol1v1ojmiiokjaajgsctltts402.jpg "/>650) this.width=650; "src="

One: Data type conversion functionWhen you work with values of different data types at the same time, SQL Server typically automatically makes a hermit type conversion. Values that are similar to data types are valid, such as int and float, but for

6.1 Configuring SQL Server products with toolsIntroduction to the 6.1.1 Configuration toolSQL Server Configuration Manager (SSCM) is the most appropriate tool in order to configure the server and client for the SQL Servers product.SSCM was first

Two databases when you merge, it's nice to have a visual tool. Someone had thought of this earlier and had an open dbdiff. Link Address: https://opendbiff.codeplex.com/This tool can be compared to tabular patterns and tabular data.But there are a