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 page splits? : SQL Server Architecture

0 Answers  

---

What is index, cluster index and nonclustered index?

0 Answers  

---

Does any body please help me what question's have asked for SSRS in the interview?

0 Answers  

---

What do you mean by 'normalization'?

0 Answers   Ernst Young, Thomson Reuters,

---

Explain the working of sql privileges?

0 Answers  

---

---

What are the new features in sql server 2016?

0 Answers  

---

What is the advantage of specifying WITH GRANT OPTION in the GRANT command?

2 Answers  

---

What is #temp and @table variable in SQL server?

0 Answers  

---

What is a mutating table error and how can you get around it?

0 Answers  

---

How would you use user_constraints table in DB?

0 Answers   Wipro,

---

Can we install sql server 2016 on windows 7?

0 Answers  

---

Delete duplicate records from the table?(Table must have unique id)

7 Answers   TCS, Thomson Reuters,

---