That is what i was thinking but wasn't sure. Thanks Perry I will give that a shot and let you know.

No I didn't specify. Thanks for the link that answered my question.

OK will do.

Thanks for the help guys. Check out this blog which gave me what i needed.

http://blogs.lessthandot.com/index.php/datamgmt/datadesign/how-to-get-information-about-all-databas/

Thanks everyone! All are good suggestions. I decided to drop and recreate the indexes on that large table which took about an hour each. I do plane on looking a...

Hi, based on EngineEdition value you provided, your SQL instance is Standard edition. Parallel index operations are available only in evaluation, developer and enterprise edition. So to run successfully IndexOptimize...

Thanks everyone! Putting the command on one line worked but now I have another problem.

When the job runs it fails with the error: 'Procedure IndexOptimize, Line 505 The value...

Yes it is Ola's

Yes they are on multiple lines. I will put it on one line and give it a try, thanks.

@alan Thanks Alan

The Paul White post is great! I learn something every time I post in this forum. I am going to setup a test using your example...

Thanks Alan

What is the syntax for make_parallel() ?

Thanks for clarifying that Jeff.

Doug

I will have to profile the data for uniqueness to see if a clustered index can be created.

I have 15 GB allocated space and 98% free

Thanks for your help.