Define Bulk Copying and Distributed Queries of SQL Server

Define Bulk Copying and Distributed Queries of SQL Server.

Bulk copying:

- It is used to transfer large amount of data.
- It allows for the efficient transfer of large amounts of data.
- It transfers data into or out of one table at a time.

Distributed Queries:

- Distributed queries in SQL server are used to reference heterogeneous data source such as a Microsoft Access database or Oracle database.
- It allows to reference data in an OLEDB data source.
- It can be another instance of SQL server.
- It exports data from a SQL Server database to an OLEDB data source.
- It imports data from an OLEDB data source into SQL server.
Define SQL Server Agent
SQL server agent is important service of the server where instances of SQL server are running.........
Difference between DELETE and TRUNCATE commands in SQL Server
DELETE TABLE is a logged operation, it is a slow process. TRUNCATE TABLE deletes all the rows........
What are constraints in SQL Server?
Constraints enforce the data integrity to the database and protect columns of the table from unwanted values........
Post your comment