Optimizing tables w/o wizard - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

Optimizing tables w/o wizard

Author

Topic

im1dermike
Posting Yak Master

222 Posts

Posted - 2008-07-28 : 14:30:30

I'm wondering how you can implement the "Optimize for multiple tables" and "Run transaction log" options when you manually create an SSIS package ie. not using the wizard.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-07-28 : 14:47:55

You just need to run ALTER INDEX to "optimize" your tables. You can use my script which does it all automatically according to fragmentation levels, just schedule it as a job.

Here's my script:
http://weblogs.sqlteam.com/tarad/archive/2007/11/27/60415.aspx

Here's all of my maintenance routines (I don't ever use the wizard, so I write my own):
http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx

And here's how I setup my production environments:
http://weblogs.sqlteam.com/tarad/archive/2008/06/30/SQL-Server-jobs-on-production-instances.aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources