[dba-SQLServer] Any gut feelings?

John,

Yes, it is possible.

Same server instance...Database.dbo.Table.Field

Separate server instance... Server.Database.dbo.Table.Field

Doris Manning
Hargrove Inc.

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of JWColby
Sent: Friday, November 03, 2006 3:55 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] Any gut feelings?

So question:  Is it possible to spread tables out across databases and use
queries that join tables in other databases (inside the same SQL Server
instance)?  The reason I ask is that I have all of these raw data tables,
which I need, need to keep around, but don't need active.  It would be handy
(for size of database files reasons) to have the raw source tables out in
their own database and the finished processed, indexed tables in another
table.  Getting the raw data into the finished data table is the issue.
Exporting 65 million records, even a few fields, to a csv file or the like
is not exactly dba friendly.


John W. Colby
Colby Consulting
www.ColbyConsulting.com