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.

How can we rewrite sub-queries into simple select statements or with joins?

0 Answers  

---

there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query that will result a horizontal output A,B,C

9 Answers   tdfc, vsworx,

---

How to connect php with different port numbers?

0 Answers  

---

what is advantages in sql 2005 over sql 2000?

4 Answers  

---

If the job running very slow what is the action you do

0 Answers  

---

---

What is row_number function?

0 Answers  

---

one table has four field id,name,design,salary. i have to find maximum salary .

6 Answers  

---

What are the differences between stored procedure and the dynamic sql?

0 Answers  

---

What is transact-sql ddl trigger?

0 Answers  

---

Write a sql query to sort on different column name according to the parameters passed in the function?

0 Answers  

---

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

0 Answers  

---

What is a db view?

0 Answers  

---