Answer / Muneesh Kumar Varshney

Fragmentation refers to the process of breaking a file into smaller fragments due to various factors like addition, deletion, or movement of data. In SQL Server, this can happen to database files as well. Defragmentation is the process of reorganizing these fragments so that they are contiguous and sequential. For a 32GB table in SQL Server, you can perform fragmentation using Database Consistency Checker (DBCC CHECKTABLE) command and defragmentation using the ALTER INDEX REBUILD command.

Answer / aina

go to start and click fragment

How to create a view on an existing table in ms sql server?

1 Answers  

---

What is the default value of an integer data type in sql server 2005?

1 Answers  

---

How you can find out if an index is useful to the optimizer?

1 Answers  

---

what is a mixed extent? : Sql server administration

1 Answers  

---

Explain the benefits of user-defined functions?

1 Answers  

---

What is read committed?

1 Answers  

---

Why de-normalization required?

1 Answers  

---

What are the types of stored procedures in an sql server?

1 Answers  

---

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

1 Answers  

---

What are indexes? When do you need to create Indexes?

4 Answers   CarrizalSoft Technologies, HP,

---

Is truncate autocommit?

1 Answers  

---

What is the command used to get the version of sql server?

1 Answers  

---