I think I need to do some more investigation to see what locks are being held.

Thanks everyone for your help. I may be back!

Duplicate or missing rows is not a concern in this instance but blocking other processes is.

Many thanks

The sp only does a select, no updates, inserts, deletes or schema modifications. Would you still expect a lock?

Thanks

Don't know if you have this sorted already but...

On each article there are properties. One is Action if name is in use. The default is to drop the object and...

Yeah thought so. Cheers

Excellent thanks. I think that option would work 🙂

If I replicate the view, I will also need to replicate the base tables wont I?

I don't really want a view over the current tables, I would like a flattened...

Mouse

Cheers 🙂

If this is run on a production server, would other queries interfer with the results. I assume because you are doing a snapshot, you do not want anything else to...

I don't show them anything otherwise they will start to ask stupid questions, if they insist

Jan - slow

Feb - better

Mar - even better

Apr - good

May - very good

Jun - good

Jul...

SQL Server doesn't know the best plan to use because the values are dynamic and therefore can't take into account value distribution etc

Thats the one 🙂

Silverfox (9/16/2009)

k.przewozniak (9/16/2009)

I have mirroring implemented on 3 servers (1- mirror, 2 - principal, 3 - witness)

The problem is that there is not only one database to be mirrored but...

There was a message to say that ID's would change for some reason. I think it is intentional