Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Ghanta
Yak Posting Veteran
96 Posts |
 Posted - 2011-07-12 : 23:33:32
|
| Hi Guys,I have data in multiple servers which are integrated using views using linked server. These data are near real time. Getting access to data using views in linked server are sometimes slow. I wanted to check what other options I have for such processing for the near real time data?Thanks! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Ghanta
Yak Posting Veteran
96 Posts |
Posted - 2011-07-14 : 09:43:15
|
| Thanks Tkizer for the response. I wanted to check one more thing is it better to create view where data resides while using linked server to access it from another server or is it faster the other way around? Thanks! |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Linked Server Views