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

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

900

---

What are cursors in ms sql server?

1109

---

Is sql server difficult to learn?

863

---

What is 'Join' and explain its various types.

1066

---

What programming language would you use to create embedded functions in ssrs?

172

---

Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

1069

---

What is report snapshot?

142

---

What is a trace frag?

1035

---

What are the differences between web role and worker role?

122

---

What is a transact-sql statement batch in ms sql server?

945

---

How to use wildcard characters in like operations in ms sql server?

1062

---

Explain about integration services of Microsoft SQL server?

981

---

Explain trigger classes i.e. Instead of and after trigger?

824

---

How to recreate an existing index in ms sql server?

984

---

Why do we use stored procedures in sql server?

894

---