I went off to read about partitioning as I understand it I would still need to write these records to the partion. So it would take as long to...

I'm moving a subset older records of the source table data. I can't rename it since I still need that for the subset of newer records. I've tried insert...

I will be moving data from a source table on the same server to a destination in the same database

I'm working with a 33-77 million record table. I need to take the data chunks off the these tables so I thought a Top 1000 delete with OUTPUT. As the...