HI

used a batch is of 10000 ,

So if i understand it correctly, if i stop the script it would rollback up to a max of 10000 ?

Thanks for responding Frederico mate

Yep, there is no SSIS installed on the test server. But this message started popup only after the execute processes task was added to...

+1 to that Phil.

Will keep SSISDB in the feature.

Happy days are here again. Thought i will share my pain with and success with rest of you.

So it seems, having expression in the connection manager does have...

Quick update. So if i remove the expressions from the connection manager things work in development mode ( username , password , server name ) persists.

Any thoughts are much appreciated.

-Is there a meterialized view that sits under the query. Might pay to rebuild the index

(This might need to be done during low usage)

-Have you got variable tables in there?...

HI

I might have you'r logic a bit fuzzed up in my head 🙂

Just to clarify

- How do you plan to rename DB_2 to DB1 + restore the...

- Yep, this is popping up on a db that's participating on AG. I am curious to know why you asked this question. I wouldn't have thought this could have...

Hi Sean

Thanks for responding,

1.) The query is a pretty straight forward LLBEGEN query

ie

declare @Sequence int ,

@A1 uniqueidentifier = newguid() -- can be any guide value

,@A2 varchar(100)...

From what i understand, you seem to have got the ducks in a row. Awesome way to minimize the potential down.

Have you thought of using a powershell script to...

Shooting in the dark 🙂

- What happens when you use option(recompile ) for the variable table, does it change the loop to a merge ( with sql 2012 SP2...

You can use the sys.dm_db_index_physical_stats DMV to get the fragmentation of the index

Few things to consider for the slowness of the queries

1.) Probably need to check the fragmentation on this table ( rebuild/reorganize the indexes)

Note the limitations...

Yep, totally agree. I come from the school of thought, but things change with sharded databases.

The question i posted is of two folds. one to sort out a...

HI

This link will give you most of the instructions of executing a SQL job remotely.

http://judepieries.blogspot.co.nz/2013/09/how-to-execute-sql-job-remotely.html

Hope this is what you are looking for.

Thanks

Jude