Shulou(Shulou.com)06/01 Report--

Process:

1. Create a new table and modify the table structure of the new table.

2. Import the data from the old table into the new table through the data flow conversion of sqlserver.

The structure of the old table:

New table structure:

Mainly changed nvarchar to varchar.

Old watch size:

New table size:

The table size has been reduced, 25.3GB.

The fragmentation of the old watch:

Fragments of the new table:

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.