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.

How to delete existing rows in a table?

1134

---

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

959

---

what is the primary use of the model database? : Sql server administration

1023

---

you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

1058

---

Why is the need for data conversion transformations?

1031

---

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

2059

---

Do you know what guidelines should be followed to help minimize deadlocks?

955

---

Can we call stored procedure in view in sql server?

889

---

What are the triggers in sql?

1071

---

Is null in sql server?

968

---

Explain identity in sql server?

988

---

what are candidate key, alternate key and composite key? : Sql server database administration

894

---

What is acid db?

867

---

what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration

972

---

What are the recovery models for a database?

1094

---