SQL Server

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.

The first method is the most traditional method. The variable in the stored procedure is used as the page multiplier. CopyCode The Code is as follows: [C-sharp] view plaincopyprint? Create proc p_paged1 @ Pagesize int, @ currentpage int As Select

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 #11: The image can be transferred immediately after the fault is detected Error Database image failover can be initiated automatically or manually. In the case of automatic initiation, the mirror server performs the failover

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,

In SQL Server, the Inner Join and Outer Join operations between common tables are performed by the execution engine based on the selected columns and whether the data has an index, the selected data is selectively converted to one of the Loop Join,

-- SQL Regular Expression replacement function Copy codeThe Code is as follows: CREATE function dbo. regexReplace ( @ Source ntext, -- original string @ Regexp varchar (1000), -- Regular Expression @ Replace varchar (1000), -- replace value @

Copy codeThe Code is as follows: Create trigger tri_wk_CSVHead_History on wk_CSVHead_History -- Declare a tri_wk_CSVHead_History trigger, Instead of insert --- the insert operation is replaced by the following Operation As Begin Declare YB

Through understanding and summarizing SQL Server database backup and restoration (I), I believe you have a deeper understanding of data backup and restoration, I did not analyze the transaction logs in the above article. Here I recommend song

The common basic points are as follows: 1. There are two types of triggers: Data Definition Language trigger (DDL trigger) and data control language trigger (DML trigger ). DDL trigger: the user responds when the user modifies the database structure

A view is a common database object that stores query results in a virtual table. The view has many advantages: 1. It can simplify operations, 2. It can set up front-end and back-end buffering, 3. It can combine and split data, 4, the most important

Clustered index, data is actually stored in order, and the data page is on the index page. It is as if all topics are arranged in order in the reference manual. Once the data to be searched is found, the search is completed. For non-clustered

The first column is grouped by goodsid. Then, the records after the group are sorted by audittime in ascending order to display the number of changes of a product. The second column is to take the final change price newPrice of the product and then