well i thought it maybe be quicker to use empty file as it would just be moving pages to a new space which is empty and splitting the IO operations...

Yeah, i had it set to run on start up with sp_procoption

i have a feeling that it cannot use the linked servers whilst on start up i also tried setting...

Well I don’t think that’s the case at all.

Above you suggest to create a SSIS package to manually import data into the MDW from different versions of SQL, Yes you...

From articles i have read they say it is only viable on sql server 2008, but i have tried searching with no luck.

It would be great if you could deploy...

Cool, thanks for the info

Just a thought, its possible that the distribution clean up agent is running under a account which doesn’t have permissions or doesn’t exist anymore worth checking.

Therefore isn’t cleaning up the...

Interesting, i am thinking about creating a stored procedure to updates stats if they are over 7 days old? or perhaps less.

If auto update is enabled the 7 day threshold...

Sure, it is something with query plan....i can see from the trace when i execute my proc from the query window within 1 or 2 mintures the logical reads and...

Thanks for you replies.

Well i am really struggling with this issue..

This Procedure has a lot of things going on, its executing nested extended stored procedures creating temp tables inserting updating.

It...

Thanks for the info, we adjusted the max dop server config from 5 to 2 the server has 4 proccessors

but is having a impact on performance but keeping the cpu...

ok sorry about the poor formatting.

Basically i need to combine data from 2 tables into 1 that have no relationship to each other. It will transfered to a monitor server...

table1

col1 col2 col3 col4

--------------------

--1---C---100---null

--2---D---200---1

table2

col5 col6

----------

Drive---D

null----null

i want the 2 table joint to look like this in the results

col2 col3...

Thanks Mike that answers my question.

Will proceed with caution.:-)

Sure i understand shrinking will make it slightly smaller and keeping all the data.

But the distribution database for replicated transaction is massive due to a inactive distributor clean up agent...