Entire books have been written on the subject.

Here's something to give you a hint of wether or not you have a problem.

/*

Cost threshold for parallelism (CXPACKET) http://sqlblog.com/blogs/jonathan_kehayias/archive/2010/01/19/tuning-cost-threshold-of-parallelism-from-the-plan-cache.aspx

Paul White: Understanding parallelism...

>

Why do you have to move those files???

It's not like they are taking 100 GB!

Use ROW_NUMBER() OVER (PARTITION BY ORDER BY)

To filter & do tie breaker.

That does WAY too much work for nothing. Doesn't log anything. Not flexible at all.

Millions of successful runs on that script =>

http://sqlfool.com/2011/06/index-defrag-script-v4-1/

Big day today, Dad's operation's confirmed, the rest of the crap is getting hauled out of the basement (which means the basement is getting hauled out of the basement)....

Declare variables, then set them and then use them to call the sp.

Reformatted =>

DECLARE

@Company varchar(3)

, @TransportGroup varchar(max)

, @EmailKey varchar(10)

, @SalesType varchar(200)

, @qwerty-2 varchar(1)

set @Company = 'test'

set @TransportGroup = 'test'

set @EmailKey...

Revenant (11/23/2011)

L' Eomot Inversé (11/23/2011)

Ninja's_RGR'us (11/23/2011)

SELECT Rules = Who cares + NULL...

Actually here's the original's author's website and latest version of that script => http://sqlfool.com/2011/06/index-defrag-script-v4-1/

Your question is like asking My car makes noise, what's wrong with it? & without taking it to the garage.

Did you capture both the good version and...

The most prolific poster post because it's the RIGHT thing to do. Not to get anything of any kind in...

SELECT Rules = Who cares + NULL 😉

@Brandie,this is somewhat easy to do.

I don't know how you do the merge at the moment or when you really want to set the print flag.

You can simply do a...