I believe there is ONE SCENARIO in which order IS guaranteed in TSQL without an explicit ORDER BY: GROUP BY with a ROLLUP or CUBE (perhaps GROUPING SETS, but I...

Once again my favorite TSQL key word (CASE) is part of the solution!!! 😎

Search this website and you will find a great stairway's series on Always On (by Perry Whittle I think).

Also that domain filter, with the leading percent, will prevent the optimizer from getting an accurate statistical estimate about row count for the predicate, thus the entire query could be...

I cannot see the picture enlarged. But it looks like 3041. Binoogle may help you there. Also, is that from Ola's job log file or the SQL Server error log?...

There is almost certainly a LOT more to the log file (note the ellipses at the end).

IIRC, by default Ola's jobs are set to create log files in...

If I break it into two parts 1-select into #temp and 2nd - insert into my destination from #temp, the 2nd part takes just 1 sec, making the whole...

Are you using the checked build of dev edition? 32 bit version by mistake? 

Watch CPU utilization on both runs, and do a differential wait stats and file IO...

Maybe this: 

TSQL Zero to Hero

Wrox used to have a beginning TSQL book that was pretty decent too.

Itzik Ben-Gan has a great...