Batches in Job

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

It will execute in order. The optimizer can re-order joins based on a better plan but it doesn't re-order batches.

HappyGeek SSCoach Points: 18729 More actions · Answer 2

Jack Corbett (3/15/2016)
It will execute in order. The optimizer can re-order joins based on a better plan but it doesn't re-order batches.

Thanks Jack, needed that confirmation and the reassurance I was not completely gaga, but still may separate them into steps.

...

U J SSCrazy Points: 2423 More actions · Answer 3

Sql statements would be executed always in a serial way regardless of specifying a go separator.

Cookies on SQLServerCentral