What is the difference between varchar and nvarchar types?

1 Answers  

---

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,

---

Explain different types of collation sensitivity?

0 Answers  

---

What is the difference between an index and a unique index?

0 Answers  

---

what is the diffrence between Snap Shot and Transaction Replication

2 Answers   CSC,

---

---

When to use Inner join & when to use subquery?

0 Answers   IBM,

---

What are user defined datatypes and when you should go for them?

1 Answers  

---

What is nested transaction?

0 Answers  

---

What is the meaning of lock escalation and why/how to stop this? : sql server database administration

0 Answers  

---

Which one is faster delete/truncate? Why?

1 Answers   Infosys,

---

How to generate create view script on an existing view?

0 Answers  

---

how to find 6th highest salary

0 Answers   Chetak Logistics,

---