Can you perform partiton switch between two tables even though two tables are in different database ( same server)?
I have table A in database A and table B in database B and i would like to use parttiion SWITCH to move data from table A to Table B.. i am using sql server 2008 R2
You can't move data between tables (let alone databases) using an ALTER TABLE statement like that. To move that data, you'd have to do an old-fashioned INSERT followed by a DELETE. Or, to do it in a single
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.