The ALTER TABLE..SWITCH command allows you to almost instantly move large amounts of data from one table to another. It does this by not physically moving the data but by updating the meta data that points to the data. I have found many uses for this statement in the past and so I thought it would make […]
Hi, I'm James Anderson. When I'm not blogging about SQL Server, I do this.