Hi,

I usually create the #temp tables in the following way:

create table #tmp(

ID int identity(1,1) prmiary key,

col1 data type c1,

col2 data type c2,

...

coln data type cn)

With this the primary key satisfies...

Good question. Possible but not practical.

I have modified the CommandExecute stored procedure of Ola so that it makes three tries in order to rebuild. I also set the deadlock priority to "LOW" but that is...

It will retry the whole process, but have...

Good question. Also it's a general recommendation to use semi-colons for all statements in t-sql codes. People usually do not always. Thanks.

I'm curious to see that...

Question's answer is wrong, i.e. the right answer is Yes. There is no point the output file creation/content be depended of the any kind of errors present during job's execution.

Post the new code here to see what you've tried, and other suggestion may come.

In your way you have a DML statement for not already existing DDL - the temp table that have to be created. The sp recompiles and it could slow down...

You're inserting directly INTO #temp table, and when in SP you could have problems. Try create the temp table first and then use the insert into #temp(col1,col2, ...,coln) statement....

I think statistics is not a topic that could be explained in a stairway, because there is not much to say about it.

This book http://www.sqlservercentral.com/articles/books/94937/ of Grant Fritchey is very...

What edition of SQL server are you using?

I run the same job on a standard edition using Ola's scripts and the job often fails but because I'm rebuilding offline and...

How are you sure that the high CXPACKET wait type is from the RPCs?

However, you could reduce the high parallelism by increasing the Cost Threshold For Parallelism (e.g. set...

TaylorMade (3/24/2015)

---

Explanation is really weak. The answer is . . ., here is some code . . . see! The supplied link states nothing about delete cascade...

Some questions for using BREAK and CONTINUE. Good. Functions behave the same as in programming languages.