Explain optimistic and pessimistic concurrency?

0 Answers  

---

what is the importence of the trigger in sqlserver2000?

1 Answers   ATI,

---

What is de-normalization and what are some of the examples of it?

0 Answers  

---

If any possiable to use 2 primary key in single table? How many primary key & foreign key used in each table(min & max)?

3 Answers  

---

What is a constant or literal in ms sql server?

0 Answers  

---

Do you know what is similarity and difference between truncate and delete in sql?

0 Answers  

---

what is DTS what are tasks available

1 Answers   Wipro,

---

How can we Use Linked Server? Uses of Linked server

1 Answers   IBM,

---

How to write a script for upate the data in prod , i have 50000 row are there

2 Answers   TCS,

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

0 Answers   HCL, Wipro,

---

Does partitioning improve performance sql server?

0 Answers  

---

why SQL server is more used to store database rather than Access

2 Answers  

---