Solved

SQL Server 2008 rebuild all indexes

Posted on 2013-06-13
5
391 Views
Last Modified: 2013-06-17
I can find several articles with scripts to rebuild all indexes, but I want to run the procedure daily at 01:30Hrs.

Any ideas how to do this?
0
Comment
Question by:grwallace
5 Comments
 
LVL 48

Assisted Solution

by:PortletPaul
PortletPaul earned 125 total points
ID: 39243925
rebuild all - or rebuild some based on (a level of) fragmentation?
0
 
LVL 4

Accepted Solution

by:
rlog earned 125 total points
ID: 39243952
Hi! Check Ola Hallengren solution. He has a ready made solution (which works great) on how to rebuild or defragment indexes. Very customizable as well and easy to install.

This solution installs 2 or 3 stored procedures in master and amongst other things an sql job called Indexoptimize. Check it out.
0
 
LVL 12

Assisted Solution

by:sachitjain
sachitjain earned 125 total points
ID: 39244473
Create a SQL job calling this procedure and schedule it running to run 01:30 hrs

Following youtube link could help you
http://www.youtube.com/watch?v=De_GOwnTDjo
0
 
LVL 23

Assisted Solution

by:nemws1
nemws1 earned 125 total points
ID: 39245915
Read rlog's comment and stop reading everybody else's.

Everybody in the MSSQL DBA profession that I know of (and that I also think highly of) uses Ola Hallengren's scripts for DB maintenance.
0
 

Author Closing Comment

by:grwallace
ID: 39252754
I have been asked to close this off without further investigation.  Key point missed out in original question was the we want the solutuion to cover "sqlserver express" editions which lack Sql Agent and the ability to create scheduled maintenance tasks.  We already used "EXPRESSMAINT" to overcome this.  But the "Ola Halengren" page looks great.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question