SQL Server

Original source: http://blog.csdn.net/dba_huangzj/article/details/38082123, featured 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

The statistical information is an important reference for the SQL Server optimizer to generate the execution plan, it needs the database developer, the database administrator has certain understanding to it, thus the reasonable and efficient

After we have built the table with SQL Server 2012, we are prompted when inserting or modifying any column: When the user changes the table structure in SQL Server 2012 Enterprise Manager, you must first delete the original table and then recreate

This article consists of Su Yi Lin Feng provide sponsorship, starting in Slime Line the world . in order to make better use of the server, it is intended to migrate the business. Because the business is special and requires the appropriate hardware

Problem Description:The company needs to make a report, according to the People organization tree, click on a node, the next direct child node display form application, according to form the status of the group.Implementation ideas:The first thing

Recently, when review code, there was a function of querying a column in the database and then generating aabcThe developer does this by returning a result set and then using the loop method to spell the string. Then parse to XMLIn fact, SQL Server

I. Non-clustered index maintenanceThe row locator value for a nonclustered index keeps the same clustered index value, even after the clustered index column is physically relocated.To optimize this maintenance overhead, SQL Server adds a pointer to

SQL Server, which quickly inserts the Excel data read by OLE DB, is used by many people to stitch through the loops to make it both error-prone and inefficient, and the best way to do this is to use BCP, which is System.Data.SqlClient.SqlBulkCopy

---restore content starts---SQL Server 2008 (1)System DatabaseMasterTempdbModuleBodyA basic skill of the database administrator (DBA) is a deep understanding of the SQL Database engine's system database. It is also useful for database developers to

First, the preparatory work:Primary database server: os:windows Server R2 db:sql server R2 Hostname:cxmasterdb ip:192.168.1.224/24 dg:192.168.1.1 dns:192.168.1.19 dns:202.96.209.133 from the database server: os:windows Server R2 db:sql server R2

Title: Connecting to a server------------------------------Unable to connect to 192.168.1.253.------------------------------Additional Information:Attempts to read or write protected memory. This usually indicates that other memory is corrupted.

Reprint: http://www.cnblogs.com/killkill/archive/2008/05/23/1205792.htmlFirst, the image introduction1. IntroductionDatabase mirroring is the move of database transactions from one SQL Server database to another SQL Server database in a different

The size of the site to a certain extent, the points are also divided, the optimization has also been optimized, but still can not meet the performance requirements of the business, we can consider the use of master-slave library.Master-Slave

In today's work, you need to access the database on the server remotely. However, connection errors, error code is 1326. To be honest, about SQL Server cannot remotely access this problem, I have encountered N times. But every time not seriously to

Like a session in. NET, if you know the SessionID in the database, all operations are known because of this unique identity.There are many things you can do, such as: What user is doing, what SQL is being executed, and how many stored procedures are

Deadlocks and blockages have always been the focus of performance test execution.Here are the monitored SQL Server databases I've compiled, whether there are deadlocks or blocked SQL statements during the performance test, and it's relatively ready

Thursday, December 5,Asp. NET to save session state there are three modes: in-process. SQL Server.Advantages of SQL Server mode:State data is saved even if the Web application is restartedMultiple Web servers can share state dataSave MemorySet up:In

I believe that everyone on the SQL Server instance name of the TCP/IP protocol is not unfamiliar, there is a TCP port, the Internet, beginners in the online tutorial, are said to configure it to 1433. Oh, I am no exception.I am deeply in the pit

SQL Server 2005 Database , we can set each user's corresponding permissions to improve the security of the database. This type of user rights setting is widely used. For example, to set a user access to a table permissions, or even crud permissions,

SQL-ORDER BY multi-field sorting (ascending, descending), SQL-order ascending Order by _ column1, _ column2;/* _ column1 in ascending ORDER, _ column2 in ascending ORDER */order by _ column1, _ column2 DESC;/* _ column1 in ascending ORDER, _ column2