copying Data from Big Data Table I have a table with around 400 GB data I want to copy some data to some other temporary database to make some more space. Can you please give me a efficient way to do that?

My DBMS is SQL server 2014 standard edition.
You want to use a minimally logged inserts. If your temp/scratch database is on the same instance you can simply do.

SELECT * INTO DATABASE.SCHEMA.TargetTable FROM SourceTable;


The above statement create the table in the target database and bulk insert the data.

If you want to copy the data to a different instance you are best off using SSIS.