Answer Posted / murtaza

INDEXES:
1.indexes are used for performance as well as query
optimization issues in database.
2.indexes are by default created when u create an primary or
unique index on a particular column in a table.
3.In sql server there are 2 types of indexes
1.clustered index
2.non clustered index
4.By default non clustered index are created in sql server 2005.
WHEN TO CREATE INDEXES:
1.indexes should be created on the tables which will be used
frequently.
2.it should be created on d tables which has large amount of
data.

Can two tables have the same primary key?

1196

---

How connect excel to sql server?

985

---

Explain different types of locks in sql server.

1068

---

what is the information that can be stored inside a bit column? : Sql server database administration

950

---

What are system databases into sql server (2005/2008) : sql server database administration

999

---

Can you create a logon trigger in sql server 2005 express edition?

1073

---

What is a heap?

1027

---

What are alternate keys?

974

---

What happens if null values are involved in comparison operations?

960

---

How do you manipulate data?

894

---

How do I create a trace in sql server?

1023

---

Can you import Microsoft Excel data to SSRS?

132

---

Why should we go for stored procedures? Why not direct queries?

1087

---

What are recommended options to be used while using db mirroring? : sql server database administration

1141

---

Do you know what is fill factor and pad index?

996

---