You have to check if your SP need to access to different databases too: in that case your user must have grants in all databases accessed by the SP
(and...

I agree with other gurus: the only way to investigate this behaviour is analyze execution plan.
May be second join cause a full table scan because of missing indexes, or...

May be you can use this metod, expecialy if your table have only append activity
create parallel tables with same structure .
Create a trigger "after insert" on two original...

Next Monday:
SELECT DATEADD(ww, DATEDIFF(ww,0,current_timestamp+6), 0)

Explanation:
Date  0  is 1900-01-01, which is a monday, so adding weeks to date 0 returns always a monday.
Adding 6 days...

1)
Are you deleting with TSQL command ? Batch size is in  Bulk insert and Integration services packages, AFAIK.
To delete with "batch size" you have to do it in...

from book "Microsoft SQL Server 2005 Integration services" by Kirk Haselden:

The SQL Server Log Provider adds log entries to the system table called sysdtslog90 and requires an OLEDB connection to...