Hi Johan,

"The null value check is performed every time the table is touched, not on a per batch level ! " - yes, that was known to me already....

Hi Thom,

Appreciate the reply. Essentially no, there isn't a NULL getting passed as [TABLE123].[accountnum1] also doesn't allow NULLS and all the values contained in that table after the...

If it makes a difference, the destination tables are not emptied, they just have additional data written to them. Before/after this runs any table constraints are removed/added. Strangely though, the...

Hi guys, thanks for your input. i didn't include every detail for fear of getting bogged-down in process. In terms of what is currently running through the night we have:

Snapshot...

Managed to get it working - as well as having 'anonymous' access allowed (like the old server) I had to also allow 'basic' 🙂

ah-ha! success...:-)

its found a ton where it is set to "." which I may filter out, but seems to be doing the trick

thanks

Luis Cazares (7/24/2015)

That's a solution, but it's not the solution. Your lengthy function, does basically what my code does in one line.

Another simple solution...

hi, thanks - unfortunately its not possible, since i would need to jump through hoops to add a function to this system and a #function isn't an option.

is the syntax...

Hi John,

Can you maybe explain what you mean by a calendar table?

Also, what is the easy way to add a zero to the single digit numericals ie 7 becomes...

Any idea why the cacheflush from the MAXDOP isn't fully working, while the DBCC FREEPROCCACHE command seems successful? Possibly a bug within SQL 2005?

Think a possible cause has been found. Overnight a MAXDOP from 1-to-4 runs, and a bit later it then sets things back from 4-to-1 - it looks like the cache...

how to check if parameter sniffing is being used? :unsure:

OK, that makes sense (only problem is that after rebooting both servers a couple of days ago the same issue happened - presumably a reboot also flushes the proc cache...

But I suppose my issue with execution plans, statistics etc is that if they are rubbish, that should persist when the database is failed back to the primary partner (the...

Found this which seems to work:

[font="Times New Roman"]SELECT GETDATE() --your query to run

raiserror('',0,1) with nowait --to flush...