Give me any three differences between Truncate and Delete.

0 Answers   Genpact,

---

I have a table emp , Fields with empname,dnname,dno,salary. now I want copy distinct salary with all emp detail from emp into new table which is not already exist in database. how would I do this ?

2 Answers   Techno Labs,

---

How can delete duplicate records in cte in sql server?

0 Answers  

---

What is the default sql server instance name?

0 Answers  

---

How to use linked server?

0 Answers  

---

If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?

2 Answers  

---

Do you know the capabilities of cursors?

0 Answers  

---

Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

0 Answers  

---

Write a program to fetch first 10 records from a file?

0 Answers   Amdocs,

---

What kind of problems occurs if we do not implement proper locking strategy?

0 Answers  

---

Whether the updations made to the views reflect the original records in the table

5 Answers   NIIT,

---

you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

0 Answers  

---