Thanks Luis. This works well for what I'm trying to achieve
Phil to answer your question the targets would be updated in the table automatically as i am extracting from...

Deque do you have offline users who sync back?

As using the "select * from sys.dm_exec_requests " I can see that there is an insert Into query that i believe...

Interesting you have the same problem as us. I had assumed it was unique to us due to the customisations we have in our CRM application. Our vendor has not...

Hi

No we do not have Read Committed Snapshot Isolation on.

I have an alert to tell me when TempDB starts to grow so I will query sys.dm_exec_requests and see what I...

Thats a good solution. IE adding the date part as part of the select statement

This extract would be run on the first day of the month for a datawarehouse type...

Hi

SSC-Enthusiastic you are correct in interpreting what i am trying to do I plan to run the package on the first day of the month.

the problem i have with with...

Thanks for your reply, Sorry i had this a little wrong, guess that happens when you do these things last thing at night

I want to "UPDATE" a column in...

It seems that no matter what BI tool you have the first thing any user does is put the data into Excel so they manipulate it

If you have a...

Thats great thanks for all your help

🙂

They are not huge in in relation to other DB's out there but in relation to itself (if you get what i mean),

The db is around 14gig

and the...

Its more the fact that we only have so much space and that this large log back up is consuming a large amount of it. Its is the difference between...

i was thinking of doing the following to combate this

normal log back up at 12.00am

The maintenance plan runs after this

which is

Db check

Index re-org

Log back up - To seperate...

so is there any way of stopping all of the index re-org stuff being written to the log, as this stuff is not really needed, and just making the log...

I'm looking forward to this product. The first thing thatanyone ever does with the information we produce using our BI tools (Hyperion) is extract the information and put it into...

Thanks for all you help.

I checked the Log while the maintence plan was running. and saw that the % used rose quite a bit due to the index rebuilt etc,...