Answer Posted / sivakumar

That command is used to rebuild indexes on tables, which
can speed up queries. You might want want to do it whenever
a large amount of data has been deleted or added. It can be
complicated to determine whether it is more efficient to do
this, or to just let the statistics rebuild automatically
so, as usual, testing is called for in each individual case
to get optimal performance.

what is isolation level at dead lock?

2151

---

What is update locks?

888

---

What is the difference between insensitive and scroll cursor?

1160

---

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

1132

---

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

1033

---

What is identity?

1015

---

What is the latest version of microsoft sql server?

1047

---

What is the difference between left and right outer join?

1063

---

How to insert data into an existing table?

978

---

How to search for a string in all stored procedure in sql server?

999

---

Why olap is used?

974

---

What are sp_configure commands and set commands?

1024

---

How to use "begin ... End" statement structures in ms sql server?

1045

---

What is table-valued sub query?

970

---

If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

1036

---