SQL Server

when doing the NLB deployment encountered such a problem ,CRMAPP1 installed the CRM version is 6.1 has hit the SP1 patch, and the CRM installation package on CRMAPP2 is version 6.0, after choosing to connect an existing deployment, the last step to

Original: SQL Server needs to monitor which countersGeneral countersCollects server performance information for operating system servers, including processor, disk, network, memoryProcessor Processor1.1% Processor time refers to the percentage that

Original: Chapter 1 securing Your Server and Network (6): Configuring Firewalls for SQL Server accessSource: http://blog.csdn.net/dba_huangzj/article/details/38082123, Special catalogue:http://blog.csdn.net/dba_huangzj/ article/details/37906349No

I. Definition and characteristics of the identity columnThe identity column in SQL Server is also called the identifier column, which is also known as the self-increment column.This type of column has the following three characteristics:1. The data

In SQL Server 2012, several conversion functions have been added to support forced conversions of data types.Since the main use of SQL Server 2008R2, the company's projects to improve development efficiency, many table columns are varchar type, but

SQL Server Audit (Audit)--Auditing and application design ArchitectureAuditing is the monitoring log on the database server, paired with the design architecture of the application, such as client-server architecture (Client-server), multi-layered

SQL Server Ring Buffer--relationship between SQL Server and ring bufferThe SQL Server operating system (SQLOS) is responsible for managing SQL Server-specific operating system resources. One of the related dynamic management attempts

I. Introduction of FILESTREAM and FiletableWe often need to store structured data (int, char, and so on) and unstructured data (such as varbinary (max)), so how do we store it?1. Before SQL Server 2008, we typically store structured data in a

 partition table in SQL Server 2005 (ii): How to add, query, and modify data in a partitioned tableCategory: SQL Server2009-12-03 15:02 13848 People read Comments (3) favorite reports SQL Serverinsert2010sqlclassAfter you have created the

Anatomy of SQL Server 13th integers storage format in row compression and page compression (translated)http://improve.dk/the-anatomy-of-row-amp-page-compressed-integers/When resolving orcamdf support for row compression, the view has encountered

Original address: http://www.studyofnet.com/news/145.htmlThis article guide: @ @IDENTITY is the last inserted identity value, the identity value is generally referred to as the autogrow value. However, if you want to return only the values that are

Monitoring preface In the previous section we mentioned the SQL event-based monitoring of MSSQL, but there are times when we need to be more detailed and suitable for tuning debugging. Visibility of running inside SQL Server is a possibility for

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

In the initial SQL Server performance issue (1/4), we learned how to quickly check the number of tasks that are running on the server instance and the number of IO waits. This is a lightweight script that does not put any pressure on the server,

An aggregate function evaluates a set of values and returns a single value. In addition to the count (number of statistics) function, the other aggregate functions ignore null values (NULL) in the formula. All aggregate functions are deterministic

Original: Initial SQL Server performance issue (4/4): List the most resource-consuming sessionsIn the last 3 articles, we discussed a list of different queries that reflect the current state of the server. Initial SQL Server performance

This article is the seventh article of the SQL Server Agent series, please refer to the original text for details In the first few of these series, you create and configure SQL Server Agent jobs. Each job has one or more steps and may contain

Landlord with SQL Server 2012 when you connect to an instance of another computer, you have been prompted to "successfully established a connection with the server, but an error occurred during the handshake before signing in." (Provider:ssl

1. Number of database backup scripts:Database backup:DECLARE @BcpFile varchar (+), @SQLBACKUP varchar (+), @BcpFullFile varchar (100)SELECT @BcpFile =convert (CHAR (8), GETDATE (), 112)SET @BcpFullFile = ' E:\BACKUP\AlarmMonitor_ ' [email protected]+

The so-called SQL Server job is to execute the specified script at the required time, and if you need to execute a stored procedure or 3200-character SQL statement at regular intervals in SQL Server , you can use management -sql Server Agent -jobs