Thank you for all the answers so far. Nice to hear (some of) you can reproduce it

Some comments to your replies:

Yes churlbut, I don't like cursors neither;) and yes, we...

I ran it on SQL 2008 R2 and SQL 2012.

I agree to Grant Fritchey as far as I'm familiar with the DTA (he sure know's better than me).

I've seen some "mistakes" in the DTA-suggestions as well.

Also, the DTA shows...

I cannot offer a solution but maybe another way to get the information you want.

For procedures, views etc. have a look at sys.sql_modules.definition, you find the DDL code there.

For SQL-Jobs...

hi,

I'm not sure what your question is. Maybe some useful hints:

"alter index" used with a specific partition_number does exactly that: it rebuildes the index(es) on that partition only.

If, for some...

hi,

I think the best way to do it is: move all the databases to the new instance.

For user databases:

If the file paths are the same you can just copy the...

There are many reasons why Service Broker can fail.

For analyzing this I recommend to disable the activation procedure. This way you can see if the data is at least reaching...

I'm not sure if Service Broker is the appropriate tool to "copy" that much databases. Maybe you should think about replication, in your case it might be transactional replication.

The only...

hi there,

I think you are talking about the activation procedure for the queue.

This is a procedure like any other store procedured. Just alter it as usual.

Get sure that your procedure...

It seems that it's not a SQL but a DB2 exception. Unfortunately i can't help you with this.

Maybe you find some DB2-specialists around somewhere...

Execution Plans and the key numbers out of the management views are a very good and not too difficult start. Of course things like RAM or CPU are other aspects...

In general: when wathcing the execution plan of the whole procedure it's quite the same than watching the single statements. Sometimes I preferr the single statements because it's easier to...

Hello Voldemar,

as far as I know the data of the profiler and the statstics-io-output is the same.

When tuning I sometimes use profiler, but just for a single procedure. I then...

Hello Jeffrey,

this is quite a difficult topic. As you mentioned there are many many many articles about this.

I don't really want to make suggestions but I tell you what I...

It think the following should do it:

create table #tmpSomeData ( col1 ..., col2... )

insert int o#tmpSomeData ( col1, col2, ... )

execute('call mySchema.myProcedure()') at DB2_Linked_Server

The table needs as much...