How to schedule ARCHIVAL AND rebuilding of Indexes in Sql server 2005?

0.00/5 (No votes)

See more:

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

Posted 22-May-14 20:26pm

Rahul 105

Add a Solution

Comments

Karen Mitchelle 23-May-14 2:31am

I suggest you use SQl Jobs.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Last 24hrs

This month

Pete O'Hanlon	115
OriginalGriff	85
Dave Kreskowiak	75
Andre Oosthuizen	45
Graeme_Grant	35

Pete O'Hanlon	1,790
OriginalGriff	1,315
Graeme_Grant	810
Richard Deeming	743
Dave Kreskowiak	634

How to schedule ARCHIVAL AND rebuilding of Indexes in Sql server 2005?

Add your solution here

Preview 0

How to schedule ARCHIVAL AND rebuilding of Indexes in Sql server 2005?

Add your solution here

Preview 0

Existing Members

...or Join us