SQL Server

Source: http://blog.csdn.net/dba_huangzj/article/details/37924127, Special catalogue: http://blog.csdn.net/dba_huangzj/article/ details/37906349 No person shall, without the consent of the author, be published in the form of "original" or used for

The following notes are used in the database, I would like to summarize, can be online a search has been, just made a supplement.Usage of ROWCOUNT:The function of rowcount is to restrict the subsequent SQL to stop processing after returning the

Using row_number () to paginate your data with SQL Server 2005 and ASPJason Witty, 20054.67 (Votes)Rate:Vote 1vote 2vote 3vote 4vote 5With the release of SQL Server 2005, Microsoft introduces the long overdue row_number () function. In this article,

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

SQL Server to troubleshoot high CPU usageThis noon, a friend asked me to help him look at the database, the operating system is WINDOWS2008R2, the database is SQL2008R2 64-bit64G memory, 16-core CPUHardware configuration is still relatively high, he

SQL ServerHow to monitor the deadlock (Deadlock)What is a deadlock? The so-called deadlock : refers to two or more than two processes in the course of execution, because of competing resources or due to the communication between each other caused by

 VBA connects SQL Server database operations to Excel.Sub button 1_click ()Dim I As Integer, J As Integer, sht as Worksheet ' i,j As Integer variable, sht as an Excel sheet object variable, point to a worksheet' Dim cn as New ADODB. Connection '

SQL Server Introduction to the use of exec and sp_executesqlMSSQL There are two commands for dynamically executing SQL statements, exec and sp_executesql, and generally, sp_executesql has the advantage of providing an input-output interface, and

Encryption in SQL Server is handled in a hierarchical form to provide multiple levels of security. SQL Server contains two key types that are used to encrypt data. Such as:1. Server Master Secret (Service master key), located at the top of the

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

A very powerful date formatting function in SQL ServerSelect CONVERT (varchar), GETDATE (), 0): 2006 10:57amSelect CONVERT (varchar), GETDATE (), 1): 05/16/06Select CONVERT (varchar), GETDATE (), 2): 06.05.16Select CONVERT (varchar), GETDATE (), 3):

Today development colleague to me, said why Reporting Services server Report Management subscription options There is only the "New subscription" option, there is no "data-driven Subscription" option, to be honest, I also basically did not use this

Contains four core features of the databaseA database that is separate from other databases and that is independent of the instance of SQL Server that hosts the database.Many of the metadata used to describe the database is maintained in that

I. Control Panel-"service-" MS SQL server-"Login-" Local SYSTEM account--"Restart MS SQL SERVERUsing Windows Authentication Login Query Analyzer--"Execute sp_password null,sa new password, ' sa 'Two. " Unable to connect to server, user XXX login

First, table variablesTable variables were first introduced in SQL Server 2000. The specific definitions of table variables include column definitions, column names, data types, and constraints. Constraints that can be used in table variables

After some friends install SQL Server 2008, most of the problems encountered connection errors such as: SQL Server 2008 Logon error: Unable to connect to (local) and so on related issues, this article will detail the solution, the need for friends

Directory:Interpreting error messagesRAISERRORTHROWInstanceUse @ @ERRORUsing Xact_abortUsing Try/catchTransactional statements in real-worldDeleteUpdateBank to withdraw moneyInterpreting error messagesMSG 547, Level A, state 0, line 11The INSERT

Job backup, not a backup database, is a backup job. My method is to export a job as a file for backup, because when your server is too large to maintain, many of your jobs become very problematic and very troublesome. It is best to synchronize jobs.

Test condition: one public IP address and two static IP addresses. Procedure: 　　 I. Can I ping the Server IP address? Check whether the physical connection of the Remote SQL Server 2000 Server exists. If not, check and view the configuration.

Query a stored procedure sharing of SQL Server database deadlocks. SQL Server Stored Procedure When SQL Server is used as the database application system, it cannot avoid deadlocks. When deadlocks occur, maintenance personnel or developers only use