UNPIVOT Command is the reverse of PIVOT command

Pivot table is use to convert column values into column name. It can be use to rotate the table.

Pivot table is use to sort,count and total data stored in one table or spreadsheet and create second table based displaying summarized table.

-Insert into select
-Select into

are the two commands to copy data from one table to another.

Sql Server Management Studio can be use to generate script of all the objects in database server.

-Detach database from one server and then attach database to another server
-Create Script of all objects and then run on another server
-User SSMS wizard

It is use to perform following tasks
-Maintainece task like indexing, file group
- Task that display more information after gathering them.
- Misc Task such as removing dll from memory

It internally use row compression and prefix compression to compress the data.

In Row compression changes the format of the physical storage of data.

Yes, variables can be declared of xml data type that can hold xml data