Hello Gentlemen,
I hope none of you most experienced persons will neglect my question. Actually I am new to Sql Server DBA.
To do Distributed Partition Views, I took 3 servers and partitioned some tables according to int range and created views in each server with same name.
Now I want to know when someone request a query on this views then, how it will work.
“The query will be executed in that server in which its where condition range falls or it will be executed in every server simultaneously? ”
Mostly i like to know how the Distributed Partitioned Views/faderated servers works to execute a query request???????????????
Thanks You in Advance
rabinarayan