SQL Server

In forums, people often ask such questions.: Why is the result set of the same query sometimes arranged in the desired order, sometimes not, or in the order of SQL2000, to sql2005/2008? In fact, as long as "order by" is not specified in the

How to restore a backup from a backup device (Enterprise Manager)Restore a backup from a backup device Expand the server group and then expand the server. Expand the "Database" folder, right-click the database, point to the "all tasks" sub-menu,

Misunderstanding #9: database file shrinking does not affect performance Error! The only condition that shrinking database files does not affect performance is that the truncateonly option is specified when there is space at the end of the file.

Misunderstanding #7: A database may have multiple images Error This misunderstanding is quite common. Each primary server only supports one backup storage. If you want to have copies of multiple master servers, use transaction log transmission.

Copy codeThe Code is as follows: -- SQL Server 2000 SELECT a. name AS field name, CASE WHEN EXISTS (SELECT 1 FROM sysobjects WHERE xtype = 'pk' AND parent_obj = a. id AND name IN (SELECT name FROM sysindexes WHERE indid IN (SELECT indid FROM

1. OUPUT parameter Return Value Copy codeThe Code is as follows: create procedure [dbo]. [nb_order_insert] ( @ O_buyerid int, @ O_id bigint OUTPUT ) AS BEGIN Set nocount on; BEGIN Insert into [Order] (o_buyerid) VALUES (@ o_buyerid) SET @ o_id = @

The first solution, the simplest and common method: Copy codeThe Code is as follows: select top 30 * from article where id not in (select top 45000 id from article order by year desc, id desc) order by year desc, ID DESC Average query time: 45

During the implementation of software projects, data import has always been a headache for the project staff. In fact, many data import methods are integrated in SQL Server. Some project implementation consultants have a headache. In the eyes of our

Default. aspx Copy codeThe Code is as follows: No title page Cellspacing = "0">Style = "FONT-SIZE: 9pt; COLOR: # ffffff; HEIGHT: 16px; BACKGROUND-COLOR: # ff9933; TEXT-ALIGN: center">Write Data from the Access database to the SQL Server

Introduction Let's take an example. Create a new class in. NET, create a new method in this class, and then call this method in SQL Server. According to Microsoft, SQL Server 2.0 significantly enhanced the database programming model through the

Master The Master database stores all the databases on the SQLSERVER entity, and it is also a binder that holds the engine. If you do not use the primary database, SQLSERVER cannot be started. Therefore, you must carefully manage the database.

If you use the DATENAME () function to obtain the full name of a month, you only need to display the abbreviated name of a month. The abbreviation of the 12 months is the same as that of the month in August. The abbreviation of other months is

Misunderstanding #30: 30 misunderstandings about backup All are wrong If you do not know the basics of backup before you start the misunderstanding of backup, please refer to my previous article on TechNet Magazine: Understanding SQL Server Backups .

Misunderstanding #29: You can build clustered indexes for the heap and DROP the indexes before performing fragment on the heap. Nooooooooooooo !!! Building a clustered index on the heap and dropping it again seems to me to be the second thing

Misunderstanding #15: CheckPoint only writes committed transactions to the disk Error This misunderstanding is due to the lack of comprehensive understanding of logs and recovery systems for a long time. CheckPoint writes all pages that have

Misunderstanding #14. After clearing the log, the related LSN will be filled with zero Initialization Error When the log file grows manually, automatic growth, and creation are performed, it will be filled in with zero initialization. However, do

Misunderstanding #22: Resource governor can control IO Error Resource tuning controllers cannot control I/O. We hope that the next version of SQL Server can support I/O control. IO control is helpful for reducing the performance impact on large

Misunderstanding #12: The number of TempDB files must be consistent with the number of CPUs Error Alas, the above misunderstanding is Microsoft's "official" suggestion, and there are still a large number of blog posts sticking to this viewpoint.

Misunderstanding #19: operations on the Truncate table will not be logged Error Operations in the User table are recorded in logs. The only operation in SQL Server that is not logged is row Version Control in TempDB. The Truncate Table statement

Misunderstanding #5: AWE must be enabled in 64-bit SQL SERVER Error! The various versions related to AWE settings that have been circulated in the workshop are confusing. For example, how to set the function, how to set the function does not work,