I did some testing on a dev box and set stats on and ran a truncate and delete in a transaction to quick check timings, truncate won.
Performing the change...

Yes, the initial identity is 1,1 I'll need to reseed this after to start again at my last max value.

Nope, it can all go, just need the identity column to be continuous.

Thanks for the replies, every day is a school day.

I am trying to get some wait stats over a period of time starting with a 1 min delay...

Hi Both,

Thanks for thodse replies.

Sadly this is a remote instance that I have no direct access to and have to do everything remotely.

The first...

Here are the contents of one of the deadlock entries -

2017-01-04 08:30:20.27 spid21s deadlock-list

2017-01-04 08:30:20.27 spid21s deadlock victim=process80393b88

2017-01-04 08:30:20.27 spid21s ...

Have followed your advice on the trace flag, as mentioned am new to this and working my way through as much as I can.

Shall post up the deadlock details when...