March 8, 2014 at 11:30 pm
Hi ,
We are having very big tables in TBS and wanted to setup a strategy for index maintenanace. PLease suggest best practices and approachees for this.
Thanking you for your time.
"More Green More Oxygen !! Plant a tree today"
March 9, 2014 at 4:52 am
I'd go with a pre-built script to do the heavy lifting. I like Michelle Ufford's scripts[/url] for doing this. Others like Ola Hollengren's.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
March 9, 2014 at 9:49 am
Minaz (3/8/2014)
Hi ,We are having very big tables in TBS and wanted to setup a strategy for index maintenanace. PLease suggest best practices and approachees for this.
Thanking you for your time.
Scripts help, big hardware helps, SQL 2014 Enterprise Edition will help even more. That will allow for partition-based index mx as well as stats updates.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
March 10, 2014 at 8:35 am
Minaz (3/8/2014)
Hi ,We are having very big tables in TBS and wanted to setup a strategy for index maintenanace. PLease suggest best practices and approachees for this.
Thanking you for your time.
Try Ola Hallengren http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html
It gives you lot of control and you can just handle a single table if needed.
--
SQLBuddy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply