Створення розподіленої транзакції
expert_db/* distributed */transaction; Orders set Supplier= Izmenen Where ID= 1 017 raquo ;; [ASH-PC] .re_ex.dbo.Orders set Supplier= Izmenen Where ID= 1 017 raquo ;; transaction;
Відкат транзакції і підтвердження транзакції
use expert_db @ Transa varchar (10)= Transa1 raquo ;; transactionTransa; Orders set Customer= x Where ID= 1016 raquo ;; [ASH-PC] .re_ex.dbo.Orders set Customer= x Where ID= 1016 raquo ;; transactionTransa; transaction; Orders set Customer= z Where ID= 1 017 raquo ;; [ASH-PC] .re_ex.dbo.Orders set Customer= z Where ID= 1 017 raquo ;; transaction
взаімоблокіровке
- Транзакція 1 - Крок 1
expert_dbTRANSACTIONOrders SET Mass= 1 000 WHERE ID= 1 008
- Транзакція 2 - Крок 2
expert_dbTRANSACTIONTransport SET MaxDistance= тисяча WHERE ID= 1 Orders SET Distance= 100 WHERE ID= 1 008 TRANSACTION
- Транзакція 1 - Крок 3
UPDATE Transport SET InRepair= 1 WHERE ID= 1 TRANSACTION
Створення індексу
expert_db; DATABASE expert_dbFILEGROUP test1fg; DATABASE expert_dbFILEGROUP test2fg; DATABASE expert_dbFILEGROUP test3fg;
- Adds one file for each filegroup.DATABASE expert_dbFILE
(= test1dat1,= C: Program Files Microsoft SQL Server MSSQL11.MSSQLSERVER MSSQL DATAt1dat1.ndf ,=5MB,=100MB,=5MB
) FILEGROUP test1fg; DATABASE expert_dbFILE
(= test2dat2,= C: Program Files Microsoft SQL Server MSSQL11.MSSQLSERVER MSSQL DATA t2dat2.ndf ,=5MB,=100MB,=5MB
) FILEGROUP test2fg; DATABASE expert_dbFILE
(= test3dat3,= C: Program Files Microsoft SQL Server MSSQL11.MSSQLSERVER MSSQL DATA t3dat3.ndf ,=5MB,=100MB,=5MB
) FILEGROUP test3fg; expert_dbPARTITION FUNCTION fnyears (Date) RANGE LEFT FOR VALUES
( 31/12/2005 , 31/12/2010 ); PARTITION SCHEME psYears AS PARTITION fnyears TO (test1fg, test2fg, test3fg); clustered INDEX Order_ID ON Orders (ID , Date) ON psYearsAll (Date);
Індексовані уявлення
USE expert_db;
GONUMERIC_ROUNDABORT OFF; ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS ON; VIEW vOrdersSCHEMABINDINGdbo.Orders.Supplier AS Постачальник, dbo.Orders.Customer AS Покупець, dbo.Orders.Date AS Дата, dbo.Criterias.Name AS Найменування, dbo.Orders.Mass AS Вага, dbo.Orders.Destination AS Адреса, .Orders.Distance AS Растояние, dbo.Orders.ID as oID, dbo.Criterias.ID AS cIDdbo.Criterias INNER JOIN. Orders ON dbo.Criterias.ID=dbo.Orders.FreightCriteriaID
- Create an index on the view.UNIQUE CLUSTERED INDEX IDX_V1
ON vOrders (oID, cID);
