Best practices dictates that all ddl should be grouped in one point (the earlier in the proc the better).

Without seing the code and requirements, it's hard for me to say...

Union ALL returns ALL rows.

Union returns distinct rows only.

Hope this helps.

Thanks for sharing this.  However from now on I'll simply add more than 1 schedule for the job.  Just to try something new .

That would catch my eye too.  I've never met this problem and I can't replicate the problem at the moment.  Can you try to do a code sample to replicate...

Point well taken.  I've never had to do anything like that so it never came to my mind.

Nice alternative .

How about scheduling it to run every day at x time.  Then have the first step of the job checking if the day of the date is greater than 7.  If so,...

Can we see the EXACT script you run?

1 - Table varaibles are a very viable solution.  You may have found one of the few exceptions there but I would NOT stop using just yet.

2 - You didn't...

Try @@ServerName.

Can you send the text execution plan too?

May I first ask the reason why you are not updating all rows in a single batch?

Select MIN(BitColumn) and don't put it in the group by...

if any row is false then all rows will return false, if all rows are true, then return true.

IsNumeric is very different that IsAllNumbers.  Here's the best way I know how to come to that conclusion (IsAllNumbers)

SELECT CASE WHEN '1/1' NOT LIKE '%[^0-9]%' THEN 1 ELSE 0 END...

I'd be curious to test this one with the profiler, but I don't have .Net installed so looks like I'll have to pass.

AFAIK, sql server will put exactly what you...