O'Reilly logo

MCTS 70-431: Implementing and Maintaining Microsoft SQL Server 2005 by Thomas Moore

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 5. Data Consumption and Throughput

Terms you’ll need to understand:

  • bcp command

  • BULK INSERT statement

  • OPENROWSET command

  • ✓ Format file

  • ✓ SQL Server Integration Services (SSIS)

  • ✓ Business Intelligence Development Studio

  • ✓ Service Broker

  • ✓ Synchronous model

  • ✓ Asynchronous model

  • ✓ Service Broker queue

  • ✓ Service Broker dialogue

  • ✓ Service Broker contract

  • ✓ Service Broker service

Techniques you’ll need to master:

  • ✓ Using BCP to export data to a file

  • ✓ Importing data by using a format file (BCP, BULK INSERT, and OPENROWSET)

  • ✓ Creating services and contracts by using Service Broker

  • ✓ Communicating between applications by using Service Broker

There are many ways to get data into and out of a database. Traditional tools for loading and unloading data with SQL ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required