Server Consolidation with SQL Server 2008
Writer: Martin Ellis
Reviewer: Prem Mehra,Lindsey Allen, Tiffany Wissner, Sambit Samal
Published: March 2009
Microsoft SQL Server 2008 supports multiple options for server consolidation, which provides organizations with the flexibility to choose the consolidation approach that best meets their requirements to centralize data services management and reduce hardware and maintenance costs. By providing centralized management, auditing, and monitoring capabilities, SQL Server 2008 makes it easy to manage multiple databases and data services, which significantly reduces administrative overheads in large enterprises. Finally, SQL Server 2008 provides the reassurance of industry-leading performance and scalability, and unprecedented control over server resource to maximize the performance of consolidated data services.
Abstract courtesy : Microsoft
Reference : Pinal Dave (https://blog.sqlauthority.com)
Server Consolidation with SQL Server 2008
Writer: Martin Ellis
Reviewer: Prem Mehra,Lindsey Allen, Tiffany Wissner, Sambit Samal
Published: March 2009
2 Comments. Leave new
Hi dave
Can you tell me please how we can retrive data from multiple database to create a report.. All the databases are under the same instance…
Make use of three part names. dbname.ownername.objectname