386
Part III: Advanced T-SQL Data Types and Querying Techniques
the result sets. For some scenarios, especially for Independent Software Vendors (ISVs) a
much simpler strategy may be to assign all customers their own database, removing the
need to allow for queries across multiple databases.When using a scale-out database strategy, you get the added resources of each of the
machines processing your workload. Having one 10GB database is not the same as having 10
1GB databases. When you have 10 1GB databases, you have distributed your workload over
many more machines, which is particularly important for high throughput.Summary
Distributed Queries and linked servers have been around for quite some time in SQL Server,
and while nothing has changed with linked servers in SQL Server 2012, knowing how to
execute distributed queries and how to improve distributed query performance is always
good to know.This chapter also covered linking to external data sources, such as Excel and Access, simply
because not all external data will come from SQL Server. Being able to access and query
data from multiple different data sources is crucial in today’s environments.c15.indd 386c15.indd 386 7/30/2012 4:50:41 PM7/30/2012 4:50:41 PM
http://www.it-ebooks.info