Answer Posted / professor r.arjunarao

TimeStamp field to detect update collisions in order to
reduce the amount of data sent to the server

example
CREATE TABLE emp (empno int PRIMARY KEY, tax int, TS timestamp)
GO
INSERT INTO emp (empno, tax) VALUES (1, 0)
GO
INSERT INTO emp (empno, tax) VALUES (2, 0)
GO
select * from emp;

1 0 0x0000000000000FA1<---Unique values
2 0 0x0000000000000FA2<---Unique values

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

622

---

What are scheduled tasks in sql server?

648

---

How to count duplicated values in a column in ms sql server?

609

---

What is the user of Primary key?

663

---

Define candidate key, alternate key, and composite key.

610

---

---

What is the sql case statement used for?

662

---

What is sub-query in sql server?

767

---

What are the lambda triggers?

568

---

Define outer join?

623

---

How much is a sql server license?

602

---

What is the maximum row of a size?

655

---

Explain can SSRS reports Cache results?

118

---

How do I find the sql server version?

616

---

can SSRS reports Cache results?

115

---

How can we improve performance by using SQL Server profiler?

658

---