如何在Sql server 2005中安排ARCHIVAL和重建索引？ [英] How to schedule ARCHIVAL AND rebuilding of Indexes in Sql server 2005?

问题描述

如何在Sql server 2005中安排ARCHIVAL和重建索引？我在数据库中拥有大量的数据内容，并且通过重建索引并且在没有用于多个服务的相同表的锁定时设置得更快。当数据变得更大以改进使用IIS 7.5中托管的服务的Web应用程序的性能时，DB的自动存档

How to schedule ARCHIVAL AND rebuilding of Indexes in Sql server 2005? I am having huge amount of data content in the DB and fetching is made faster by rebuilidng indexes and setting no locks where same tables used for multiple services. Also an automatic archival of DB when data gets bigger to improve the performace of the web application with services hosted in IIS 7.5

推荐答案

这篇关于如何在Sql server 2005中安排ARCHIVAL和重建索引？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！