SQL Server

Project backgroundThis is to a data center to do a project, the project is very difficult, the project really makes me feel, the mall like battlefield, and I just one of the soldiers, too many tactics, too many high-level contest, too much insider.

Many developers in the database design often do not have much to consider char, varchar type, some are not pay attention to, because the storage price has become more and more cheap, forget the beginning of some basic design theory and principles,

Look at the SQL Server Big v Song blog post and discover an interesting SQL Server-level summary data issue. The specific questions are as follows: parent_id emp_id emp_name total_amoutNULL 2 Andrew 2002 1 Nancy 1002 3 Janet 1203 4 Michael 801 5

　　　When I recently helped the customer with the issue of publishing subscriptions, I suddenly encountered an issue in which the following errors were reported in the publication subscription, and an error occurred while performing the ALTER TABLE

Recently there is a project response, in the server CPU usage is high, our Event query page is very slow, query a few records unexpectedly 4 minutes or more, and in the second page to take so much time, this is certainly unacceptable, but also let

Original: SQL Server optimizer features-dynamic retrievalSome time ago I wrote the article SQL Server implicit conversion caused by lying gun deadlock in some friends commented back said that in the SQL2008R2 test did not appear deadlock, their

SQL Server database built-in account SA does not log on when you set the SQL Server database to the SA password 18456 Resolution step: Step Two: Right-click SA, select Properties: Step Three: Click the Status tab: Tick Grant and enable. Then

From:SQL Server Query performance optimization-heap table, fragmentation, and index (i)SQL Server Query performance optimization-heap table, fragmentation, and index (ii)SQL Server Query performance optimization-overwrite index (i)SQL Server Query

SQL Server row and column conversion Pivot UnPivotPivot 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

Parameter sniffing is a function of generating an execution plan based on the parameters passed in when SQL Server creates the execution plan for a stored procedure, in layman's terms, the execution plan is generated based on the first parameter for

Usually we check the weight, and filter the duplicates according to a certain condition.SELECT * FROM dbo. T_ecert Awhere (A.ecertid) in (select Ecertid from T_ecert GROUP by Ecertid+idcard have count (*) > 1)But what if you need to have multiple

There are many reasons why the query is slow in practice because of the several methods of optimizing SQL Server database, the most common of which are the following: No index or no index (this is the most common problem of slow query, is the defect

1 one, SQL Server paging:2 SELECT TOP(Number of data bars displayed per page)* fromTable nameWHERE(ID not inch(SELECT TOP(The current page-1）*Number of data bars displayed per page-1) ID fromTable name asTable name 1_1ORDER byID))ORDER byID;3

/"Server error in the application.Failed to generate a user instance of SQL Server because of an error in retrieving the user's local application data path. Make sure that the user has a local user profile on this computer. The connection will be

Create PROCEDURE Mytestprocname (in score int, out result varchar (100))BEGINIF Score>60 ThenSet result= ' yes ';ELSESet result= ' no ';END if;ENDCallCall Mytestprocname (@result);Select @result//In order to see the results of the referenceA little

SQL Server Defragment index fragmentation testThe way SQL server organizes indexes is just a few, and always smart to join the intelligent judgment very uncomfortable, or worse than Dbms_advisor:1SQL SERVER 2000/2005Inquire 2000Use

Installation diagram:Install. NETThere's something wrong, can't do that, then go to Server Manager to installOpen the Feature Setup Wizard and select. NET, which requires installation. Other roles required by netStart installationIIS role, default

SQL Server Database FundamentalsFirst, install the SQL Server databaseSetup.exe-> Installation--New SQL Server standalone installation or add features to an existing installation---Enter serial number---next to the default instance, mixed

In today's article I would like to talk about the more advanced, lightweight synchronization objects that SQL Server uses: latches (Latch). A latch is a lightweight synchronization object used by the SQL Server storage engine to protect

Five paging stored procedures based on SQL Server and Performance Comparison In SQL Server database operations, we often use stored procedures to implement paging processing of the queried data to facilitate browsing by viewers. Create a database