There are now two main hard disk interface technologies on the server, SATA and SCSI, and the products that use SAS hard drives are currently listed, and of course high-end optical drives, the first two of which are the most common. Here we have a brief introduction to SATA, SCSI, SAS and other interface technologies.
Sata
SATA (serial Advanced Technology attachment) is the abbreviation for Serial ATA, which is currently available SATA-1 and SATA-2
How to use filegroups to solve the poor reading and writing performance of large data volumes, the following steps:In Enterprise Manager, right-click your database, select Properties, select Data file, add one, fill in the file, fill in the location, file group, such as ABC---OK.Then you can right-click on the table in your database, design the table, then right-click Properties, and then change the table filegroup and text file group to ABC, the original table from the original large MDF file i
] Asc[ID] ASC)GO or in the GUI. Two, the root node structure of the combined index First look at the physical structure of the table --Turn on trace flagDBCC TRACEON (3604,2588)--DBCC Traceoff (3604,2588)---Gets the data page of the object, structure: Database, object, displayDBCC IND (ixtest,users,-1) Viewing the contents of the first index leaf node DBCC page (ixtest,1,201,3) Note: 1. when a composite index query does not contain columns, the RID query is still gone. 2. If it is an include
non-overwrite update, it will cause the movement of the data rows during the page splitting process:(1) The move of the clustered index has no effect on the nonclustered index, because the key value of the clustered index is stored in the nonclustered index, and the split does not change the key value;(2) The data page in the heap table splits, leaving a forward pointer at the original record to tell the nonclustered index where to find the new record;So the movement of data rows does not cost
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.