WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN SQL SERVER?

8 Answers  

---

Explain the disadvantages of cursors?

0 Answers  

---

How to recompile stored procedure at run time?

0 Answers  

---

What is the difference between varchar and varchar types?

0 Answers  

---

select names starts with a,b,c

8 Answers   Scope International,

---

explain different types of backups avaialabe in sql server? : Sql server database administration

0 Answers  

---

What is the difference between a Local temporary table and a Global temporary table? How is each one used?

2 Answers   HCL,

---

What does it mean to normalize a database and why would you do it?

0 Answers  

---

1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

0 Answers   Aptroid,

---

What is partition, how will you implement it? : sql server analysis services, ssas

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  

---

How do I find the query plan in sql server?

0 Answers  

---