What are Distributed Queries [Resolved]

Posted by Amatya under Sql Server on 2/16/2016 | Points: 10 | Views : 595 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

What are Distributed Queries and where we can use it?

Feel free to share informations.
mail Id ' adityagupta200@gmail.com
Thanks

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Rajnilari2015 on: 2/16/2016 [Member] [Microsoft_MVP] [MVP] Platinum | Points: 50

0	@Amatya Sir, Distributed queries involve to query data that's stored on another server. In another way, if we want data from various sources, we need distributed queries. This is done because of the need of disparate Data Storage Needs and also for data security. Polygot persistence/storage is the need of the day and distributed queries are one among those solutions for the cry . In one of your question ( http://www.dotnetfunda.com/forums/show/21048/what-is-linked-server-in-sql-server ), we discussed about Linked Server. It is a way to make distributed queries. Hope this helps -- Thanks & Regards, RNA Team Amatya, if this helps please login to Mark As Answer. \| Alert Moderator

@Amatya Sir,
Distributed queries involve to query data that's stored on another server. In another way, if we want data from various sources, we need distributed queries. This is done because of the need of disparate Data Storage Needs and also for data security.

Polygot persistence/storage is the need of the day and distributed queries are one among those solutions for the cry .

In one of your question ( http://www.dotnetfunda.com/forums/show/21048/what-is-linked-server-in-sql-server ), we discussed about Linked Server. It is a way to make distributed queries.

Hope this helps

--
Thanks & Regards,
RNA Team

Amatya, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Karthikaqpt on: 4/20/2016 [Member] Starter | Points: 25

0	SQL Server users can use distributed queries to access the following: Distributed data stored in multiple instances of SQL Server. Heterogeneous data stored in various relational and nonrelational data sources accessed by using an OLE DB provider. Lean sql basics from https://www.youtube.com/watch?v=7Vtl2WggqOg Software testing\|SeoTools Amatya, if this helps please login to Mark As Answer. \| Alert Moderator

SQL Server users can use distributed queries to access the following:
Distributed data stored in multiple instances of SQL Server.
Heterogeneous data stored in various relational and nonrelational data sources accessed by using an OLE DB provider.
Lean sql basics from https://www.youtube.com/watch?v=7Vtl2WggqOg

Software testing|SeoTools

Amatya, if this helps please login to Mark As Answer. | Alert Moderator

Latest Posts