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 is difference between temp table and cte?

545

---

What is a recursive stored procedure in sql server?

576

---

Explain identity in sql server?

569

---

What are the types of resultset?

541

---

What are the tool windows in sql server management studio? : sql server management studio

628

---

---

What xml support does the sql server extend?

539

---

Explain about system stored procedure?

609

---

What is sql server english query?

549

---

How exceptions can be handled in sql server programming?

553

---

What are different types of collation sensitivity?

544

---

Explain index in sql server?

600

---

Is mysql better than sql server?

545

---

How do I know if localdb is running?

521

---

What triggers long term care?

565

---

How to list all tables in the database using odbc_tables()?

572

---