Answer / guest

Updates information about the distribution of key values for
one or more statistics groups (collections) in the specified
table or indexed view.

Answer / sambashiva

This is used after inserting huge rows into table or deleting from a table the pages of the index will be not in the proper way so by running this thing we can bring them to proper way.

what kind of lan types do you know? : Sql server database administration

0 Answers  

---

What is the difference between SSAS 2000 and SSAS 2005?

1 Answers   APX,

---

Why are you getting errors when creating a new odbc dsn?

0 Answers  

---

Explain external key management in sql server 2008

0 Answers  

---

What is Dependency Injection and provide example?

0 Answers  

---

What is the difference between in and exists. Ex: select * from emp where empno in(....) and select * from emp where empno exists(....) What is the difference between a Join and Union and Union and UnionAll.

5 Answers   ABC, Accenture,

---

What is row_number () and partition by in sql server?

0 Answers  

---

What is dbcc?

0 Answers  

---

There is table like Events...in that name ,startdate ,enddate,location are the column names write a stored Procedure for this table to get events by Months "GetEventsByMonths"

2 Answers  

---

What is the difference between osql and query analyzer?

0 Answers  

---

Explain the difference between primary keys and foreign keys?

0 Answers  

---

Explain indexed views?

0 Answers  

---