What are the types of indexes?

0 Answers  

---

if a parameter is not send to a stored procedure what type of identifier is to be used in Stp and if that parameter is not feed to the a query inside the Stp how to validate with out useing IF condition

1 Answers   Aviva,

---

How do you open a cluster administrator?

0 Answers  

---

What is spid in sql server profiler?

0 Answers  

---

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

0 Answers  

---

How to enable/disable indexes?

0 Answers  

---

Describe the functionalities that views support.

0 Answers  

---

hi friends please answer this question ASAP:- how to count the no. of employee in a each department or no. of employee in each location by using emp/dept table

7 Answers   Indecomm,

---

what are default? Is there a column to which a default cant be bound?

1 Answers  

---

what is the main difference between constraints(like primary key etc..)& joins?

2 Answers  

---

How do you manipulate data?

0 Answers  

---

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

0 Answers  

---