Answer / srinivas

Index is a database object which improves the efficiency of
the query

Answer / guest

When queries are run against a db, an index on that db
basically helps in the way the data is sorted to process the
query for faster and data retrievals are much faster when we
have an index.

Answer / uma

index is used to speed up query execution,indices are used
to locate the tables in the database.

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

0 Answers  

---

Explain primary key?

0 Answers  

---

What happens if null values are involved in datetime operations?

0 Answers  

---

What is the difference between a local and a global temporary table?

0 Answers  

---

What is best institute to Learn DotNET And SQL in chennai?

0 Answers  

---

---

What are the different types of stored procedures?

0 Answers  

---

What does it mean to have quoted_identifier on? What are the implications of having it off?

2 Answers  

---

How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

0 Answers  

---

Explain time data type in sal server 2008?

0 Answers  

---

What is the difference between temp table and table variable?

8 Answers   Microsoft,

---

can you any body tell me which service pack is installed in the sql server?

3 Answers  

---

What is the default server name for sql server?

0 Answers  

---