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.

What are drilldown reports?

154

---

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

1064

---

What is the default order of an order by clause?

996

---

What are the advantages to use stored procedures?

1109

---

What is the difference between varchar and nvarchar?

941

---

What is row_number function?

1011

---

What are different types of database indexes?

1102

---

What is open database communication (odbc)?

1063

---

How network traffic be reduced by using the stored procedure?

1118

---

What is mscorsvw.exe - process - microsoft .net framework ngen?

955

---

What is a covered index?

939

---

How column data types are determined in a view?

961

---

What are the dmvs? : sql server database administration

1061

---

Explain alternate key, candidate key and composite key in sql server?

916

---

What is the current pricing model of SQL Azure?

104

---