SQL Server

Original: SQL Server session Kill, always in the Killed/rollback state situation analysisToday, a very strange situation, found a session exception, this session is simply executing a simple stored procedure, which uses the linked server (Linked

1. LockConcurrency problems occur when multiple users modify the same data at the same time, and a transaction can be used to solve the problem. However, in order to prevent other users from modifying the data in another transaction that is not yet

The main considerations for designing SQL Server indexes are as follows:Check where condition and join condition column;Use narrow index;Check the selectivity of the column;Check the data type of the column;Consider the order of the columns;Consider

Version control is a well-known concept in the software development process. Because a project may require the involvement of different actors, using version control software allows people of different roles in the project to participate in the

ObjectiveThis article continues to play the content of the module, about the location of the index in SQL Server No need to say, this article will analyze how to use the Hint Bootstrap statement to fully use the index to run, as well as a solid

ObjectiveIn the previous article we analyzed the role of statistical information in the database, and we have learned how the database uses statistics to control the distribution of the contents of tables in the database. Children's shoes are not

SQL Server 2014 Log Shipping Deployment (1): Log shipping Overviewhttp://281816327.blog.51cto.com/907015/1598309SQL Server 2014 Log Shipping Deployment (2): Log shipping system requirements and experimental

ObjectiveAfter the analysis of the previous few, in fact, in general has been the first glimpse of the importance of SQL Server statistics, so this article will be sacrificed this artifact.This content will be very long, sit good bench, melon seeds

Normal spacesBefore and after spaces, use LTrim and RTrim, for example: LTrim (RTrim (Name))Middle space, replace with replace function, for example: replace (Name, ' ', ')If it is an ordinary space, it is easy to replace, but sometimes encounter

Pivot is used to rotate column values to column names (row to column), and SQL Server 2000 can be implemented with an aggregate function with a case statementThe general syntax for pivot is: Pivot (aggregate function (column) for column in (...)) As

SQL Server Connectivity Issues Bible-Named pipes (1) APGC DSD Team12 Jan 1:24 AM 3 One. ObjectiveIn the process of using SQL Server, the most users encounter is the connection problem. This article will discuss all aspects of SQL

Original: SQL Server Performance Tuning Training IntroductionHello everybody, this is the first blog post I wrote in the blogging park, and the reason I want to open this blog is a record of my interest in MS SQL Technology learning. As a computer

WIN2008 R2 installed on the server, and then did not care about the machine name, after installing the SQL2008 R2 database, configure the ad domain to modify the machine name.Then, when you start configuring Database mirroring synchronization, try

Problem: The External host management platform appears when the database is activated. Microsoft ole db provider for SQL Server Error '80040e87' Conversion from string to datetime failed. /ADM/admsql3.asp, row 271 Cause: You can view the logon

After reading the Microsoft product demonstration, I felt that this report tool was not bad. So I downloaded SQL Server 2000 reporting services. Unfortunately, it was an evaluation version. I don't know where to get the official version. I feel

Microsoft officially released the webmatrix web development platform yesterday. The product was tested as early as last year.Webmatrix is a one-stop and simplified development process. Compared with Visual Studio or visual web developer, webmatrix

Decimal () indicates that the decimal point is 14, and the decimal point is 4. the decimal point includes all valid digits, including the decimal point, the number before the decimal point, and the number after the decimal point. Decimal (numeric)

Obtain the table field name (SORT ): SELECT. name as field name FROM syscolumns a inner join sysobjects d on. id = d. id and d. xtype = 'U' and d. name <> 'dtproperties' where d. name = 'table name' order by. id,. colorder Expected table field name:

SQL server uses convert to obtain datetime date data. The following examples include conversions of various date formats.Statement and query result:SelectCONVERT (varchar (100), GETDATE (), 0): 05 16 2006 AMSelectCONVERT (varchar (100), GETDATE (), 1

Simple Method for setting ID field auto-increment when creating a table on SQL server, SQL Field Open the database table to be set and click the field to be set, such as id. The column attribute table of id appears below. In column attributes,