How can I avoid Torn pages

How can I avoid Torn pages

 

  

Dear Friends,

Could anyone please let me know how can i delete torn pages from my database
and reindex the tables.

Thans in Advanced.

Rgds,
VSN

MS Sql Server LazyDBA home page