August 2012
Intermediate to advanced
1416 pages
33h 39m
English
book
Microsoft SQL Server 2012 Bible
by Adam Jorgensen, Jorge Segarra, Patrick LeBlanc, Jose Chinchilla, Aaron Nelson
Content preview from Microsoft SQL Server 2012 Bible
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Partitioned Views
The concept of partitioned views was introduced with SQL Server 2000. You can partition a view locally, which means that all the underlying tables are stored on the same SQL Server instance. You can also base a view on tables distributed across multiple servers, which is known as a distributed partitioned view. The databases are said to be federated. You can use linked servers to union all the data through views.
With the data split into several member tables, of course, each individual table may be directly queried. A more sophisticated and flexible approach is to access the whole set of data by querying a view that unites all the member tables — this type of view is called a partitioned view.
The SQL Server query processor is designed specifically to handle such a partitioned view. If a query accesses the union of all the member tables, the query processor can retrieve data only from the required member tables.
A partitioned view not only handles selects, but also data can be inserted, updated, and deleted through the partitioned view. The query processor engages only the individual tables necessary.
Note
The individual tables underneath the partitioned view are called member tables, not to be confused with partitioned tables, a completely different technology, covered in the next major section in this chapter.
Local-Partition Views
Local-partition views access only local tables. For a local-partition view to be configured, the following elements must ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.