Lab Create a separate file for your lab report. DO NOT submit the entire module. Part...

 

Transcribed Image Text:

Lab Create a separate file for your lab report. DO NOT submit the entire module. Part I SQL Server: SHOWPLAN Objectives: 1. Import and Export Bulk Data by Using the bcp Utility 2. Compare different queries using EXPLAIN PLAN 3. Test yourself that indexes do not come for free Instructions 1. Learn how to use BCP utility to copy TransactionHistory table from the database to a file. a) Connect to CSE Vlab SQL Server VM Dject Explorer Connect = B SQL2019-8 (SQL Server 15.0.2000.5-1 Databases System Databases natahara Snanchote b) Check the name of MS SQL Server. In my example SQL2019-2 c) Open Windows Explorer and create a new directory tmp on D:\ Lab Create a separate file for your lab report. DO NOT submit the entire module. Part I SQL Server: SHOWPLAN Objectives: 1. Import and Export Bulk Data by Using the bcp Utility 2. Compare different queries using EXPLAIN PLAN 3. Test yourself that indexes do not come for free Instructions 1. Learn how to use BCP utility to copy TransactionHistory table from the database to a file. a) Connect to CSE Vlab SQL Server VM Dject Explorer Connect = B SQL2019-8 (SQL Server 15.0.2000.5-1 Databases System Databases natahara Snanchote b) Check the name of MS SQL Server. In my example SQL2019-2 c) Open Windows Explorer and create a new directory tmp on D:\