I didn’t mean not log at all. I just don’t want it to use one continuous transaction to load 2.5 billion records. SSIS is doing it in batches freeing up...

Sorry guys. This was a drive by. A quick post in the heat of the moment. I thought i was going to have to change the identity on a 2.5...

To close the loop here. I'm my case the table in question was a prod table anyhow so I had to fix it in prod. All inserts were failing.

The...

i killed it. It was running for 8 hours. dont know what else to do to be honest. How long do you suspect the rollback will take?

The plan:

in the meantime...

so the log space used on the log file was at 357,655 megs on 8/11

now it's at 365,908 megs. This process has been running for 6 hours at this point....

are you saying that teverytime we wnat to do a stapshot we will have to drop and recreate the view?

OK, so you agree, it shouldn't run any faster simply because i'm remoted into the prod server.

What about querries? Should the same logic apply? It's been my experience that...

it would seem that all of the processing of the index rebuild should occur on the prod sql server box. That must not be the case however.

sorry. I wasn’t being very clear. What I mean is when run the index rebuild from my local computer connecting to the prod instance through Management studio the rebuild takes...

Perfect, that's what I was thinking. With that in mind I suspect my issue will come back even though I optimized the procedure. My issue is our prod sql server...

but u can log ship from enterprise to standard?

Does sql server 2016 have anymore options? Theoretically we could change this to sql 2016 ent. for the primary and sql 2016 standard for the read only secondary reporting db.

is database mirroring available in sql server 2014 standard?

im reading that 1204 needs to be activeated for all sessions in order to get the XML graph. At the moment i've got it set to sessions = 0. If...

i've uploaded the example output. Notice thextra carrage return line feed at the end.