Showing posts with label separate. Show all posts
Showing posts with label separate. Show all posts

Monday, March 19, 2012

joining multiple mdfs

Hi all,
I have a database that I'll be moving to a new machine. The existing setup
has the data in 3 separate mdf files. The new machine has more than enough
space to accommodate the 3 files in the same location, as well as enough
room
to grow for the foreseeable future.
I've done a test load of the existing data onto the new server from the .bak
dump file. Since the data was in 3 files I had to restore it into 3 files. I
was wondering if it's possible (and how I would go about it) to join the
separate mdfs into one large one.
Thanks in advance for any replies.
Ricknever done this but I think you can do this with ALTER DATABASE. Check it
out in BOL or http://support.microsoft.com/?kbid=814576
"Rick" <reddinger@.serif.com> wrote in message
news:%237o9PqbFEHA.624@.TK2MSFTNGP10.phx.gbl...
> Hi all,
> I have a database that I'll be moving to a new machine. The existing setup
> has the data in 3 separate mdf files. The new machine has more than enough
> space to accommodate the 3 files in the same location, as well as enough
> room
> to grow for the foreseeable future.
> I've done a test load of the existing data onto the new server from the
.bak
> dump file. Since the data was in 3 files I had to restore it into 3 files.
I
> was wondering if it's possible (and how I would go about it) to join the
> separate mdfs into one large one.
> Thanks in advance for any replies.
> Rick
>
>|||Thanks, that worked. Come to realize you can also do this through the GUI in
the "Shrink files" dialog, saves some typing
Thanks again.
"ME" <mail@.moon.net> wrote in message
news:OHpXEAcFEHA.2408@.TK2MSFTNGP10.phx.gbl...
> never done this but I think you can do this with ALTER DATABASE. Check it
> out in BOL or http://support.microsoft.com/?kbid=814576
> "Rick" <reddinger@.serif.com> wrote in message
> news:%237o9PqbFEHA.624@.TK2MSFTNGP10.phx.gbl...
setup
enough
> .bak
files.
> I
the
>

joining multiple mdfs

Hi all,
I have a database that I'll be moving to a new machine. The existing setup
has the data in 3 separate mdf files. The new machine has more than enough
space to accommodate the 3 files in the same location, as well as enough
room
to grow for the foreseeable future.
I've done a test load of the existing data onto the new server from the .bak
dump file. Since the data was in 3 files I had to restore it into 3 files. I
was wondering if it's possible (and how I would go about it) to join the
separate mdfs into one large one.
Thanks in advance for any replies.
RickOne possible solution is to restore the database on to the new server and
then use DTS transfer the objects to a new database.
There is not a way to combine the mdf files.
Rand
This posting is provided "as is" with no warranties and confers no rights.

Monday, March 12, 2012

Joining Data between 2 SQL Server machines

I’m trying to retrieve data from between two separate SQL server machines.
I
have Server A and B on separate machine. Server A contains the majority of
my data and I’m developing my select on that server. I’ve discovered th
at I
also need data from Server B. How do I accomplish this?
Code:
Select ColumnA, ColumnB, ColumnC
From TableA inner join
ColumnA ON
(Select ColumnD, ColumnE
From ServerB.dbo.TableG.ColumnD) = ColumnA
where ColumnB = 1
I only need to retrieve two columns from server B and join them in my
select on server A.You'll need to create a linked server. See
http://msdn2.microsoft.com/en-us/library/ms190479(SQL.90).aspx
for information on the topic. After the linked server is defined, you can
query the table on Server B using a four-part name:
SELECT * FROM ServerB.[database name].dbo.[table name]
"Larry Bird" wrote:

> I’m trying to retrieve data from between two separate SQL server machine
s. I
> have Server A and B on separate machine. Server A contains the majority o
f
> my data and I’m developing my select on that server. I’ve discovered
that I
> also need data from Server B. How do I accomplish this?
> Code:
> Select ColumnA, ColumnB, ColumnC
> From TableA inner join
> ColumnA ON
> (Select ColumnD, ColumnE
> From ServerB.dbo.TableG.ColumnD) = ColumnA
> where ColumnB = 1
> I only need to retrieve two columns from server B and join them in my
> select on server A.
>

Joining cubes

I have three cubes in AS. How can I have a separate cube which can retrieve
data from these three cubes and then (similar to join function in T-SQL)
can join the results?
Thanks,
Gilgamesh
there is no join option for cubes.
but you can use virtual cubes (in AS2000) or link the cubes (SSAS2005)
when you link 1 cube in another, the user is able to access the measures of
the 2 cubes at the same time.
you have to use shared/common dimensions to be able to analyze the measures
of the 2 cubes at the same time. (like 1 common time dimension)
"Gilgamesh" <gilgamesh4ever@.aol.com> wrote in message
news:ukwtRNGYHHA.1240@.TK2MSFTNGP04.phx.gbl...
>I have three cubes in AS. How can I have a separate cube which can retrieve
> data from these three cubes and then (similar to join function in T-SQL)
> can join the results?
> Thanks,
> Gilgamesh
>
|||How do you share dimensions? I tried nameing them the same in all thecubes,
but when I drag and drop the dimensions to the browser it creates separate
columns even though they're called with the same name.
-G
"Jeje" <willgart@.hotmail.com> wrote in message
news:5E0F1674-B392-4739-82CE-2ED8657CF469@.microsoft.com...[vbcol=seagreen]
> there is no join option for cubes.
> but you can use virtual cubes (in AS2000) or link the cubes (SSAS2005)
> when you link 1 cube in another, the user is able to access the measures
> of the 2 cubes at the same time.
> you have to use shared/common dimensions to be able to analyze the
> measures of the 2 cubes at the same time. (like 1 common time dimension)
>
> "Gilgamesh" <gilgamesh4ever@.aol.com> wrote in message
> news:ukwtRNGYHHA.1240@.TK2MSFTNGP04.phx.gbl...
|||do you use AS2000 or 2005?
is AS2000 shared dimensions are created in the shared dimension tree of the
management console.
use the SAME dimension in both cube to be able to analyze the measures of
the 2 cubes at the same time.
in 2005 all the dimensions are shared by default, so use the same dimension
in both cubes.
having the same name is not enough.
"Gilgamesh" <gilgamesh4ever@.aol.com> wrote in message
news:eH3aUcdYHHA.2316@.TK2MSFTNGP04.phx.gbl...
> How do you share dimensions? I tried nameing them the same in all
> thecubes, but when I drag and drop the dimensions to the browser it
> creates separate columns even though they're called with the same name.
> -G
> "Jeje" <willgart@.hotmail.com> wrote in message
> news:5E0F1674-B392-4739-82CE-2ED8657CF469@.microsoft.com...
>
|||Ok. I'm getting very close. How can I combine three fact tables into one? In
other words, how can I JOIN them?
-G
"Jeje" <willgart@.hotmail.com> wrote in message
news:9234EA65-4AA3-4983-86E1-360F679BA035@.microsoft.com...[vbcol=seagreen]
> do you use AS2000 or 2005?
> is AS2000 shared dimensions are created in the shared dimension tree of
> the management console.
> use the SAME dimension in both cube to be able to analyze the measures of
> the 2 cubes at the same time.
> in 2005 all the dimensions are shared by default, so use the same
> dimension in both cubes.
> having the same name is not enough.
> "Gilgamesh" <gilgamesh4ever@.aol.com> wrote in message
> news:eH3aUcdYHHA.2316@.TK2MSFTNGP04.phx.gbl...
|||well... joining 3 fact tables its different.
can you explain what are the 3 tables and the 3 associated cubes you have.
and the version of the tools (SQL2000 or 2005)
take a look at the foodmart sample or the adventure works sample to see how
different fact tables are combined into 1 cube.
"Gilgamesh" <gilgamesh4ever@.aol.com> wrote in message
news:O4gUZDfYHHA.3628@.TK2MSFTNGP02.phx.gbl...
> Ok. I'm getting very close. How can I combine three fact tables into one?
> In other words, how can I JOIN them?
> -G
> "Jeje" <willgart@.hotmail.com> wrote in message
> news:9234EA65-4AA3-4983-86E1-360F679BA035@.microsoft.com...
>
|||I'm using AS2005. I started by creating three differentd data source views
and then created one cube for each view. i.e. one cube for Orders, one for
Invoices, and one for Receipts. That part works fine. Now I need to either
create a fourth cube, or maybe somethings else, whcih allows me to comine
the records of three fact tables into one view. I'll need specifcally six
columns of each fat tables, which have been named the same, to be included
in the new fourth cube.
The issue is not to combine multiple fact tables into one cube. The issue,
maybe, is to combine multiple fact tables into one fact table and then use
that table in a cube.
-G
"Jeje" <willgart@.hotmail.com> wrote in message
news:AB50D69A-F1BB-455D-88EB-63B8B4EE9A4E@.microsoft.com...[vbcol=seagreen]
> well... joining 3 fact tables its different.
> can you explain what are the 3 tables and the 3 associated cubes you have.
> and the version of the tools (SQL2000 or 2005)
> take a look at the foodmart sample or the adventure works sample to see
> how different fact tables are combined into 1 cube.
>
> "Gilgamesh" <gilgamesh4ever@.aol.com> wrote in message
> news:O4gUZDfYHHA.3628@.TK2MSFTNGP02.phx.gbl...
|||ok, now I see
first use only 1 DSV and add all the tales used in this unique DSV; add the
correct relationship between fact tables and dimension tables.
after, create only 1 cube and 3 measure groups each one linked to the 3
tables;
now you have 1 cube with the measures from the 3 source tables.
the cube wizard will create everything for you if the DSV contains enough
information (ie good links).
again, take a look at the adv. works sample to see how this works.
if your tables come from 3 different database, and if you are not familiar
with SSAS, try to copy your tables into the same database to simplify your
project.
or use the linked servers + views, but try to have only 1 source database
for your cubes.
"Gilgamesh" <gilgamesh4ever@.aol.com> wrote in message
news:enT0ScoYHHA.4008@.TK2MSFTNGP05.phx.gbl...
> I'm using AS2005. I started by creating three differentd data source views
> and then created one cube for each view. i.e. one cube for Orders, one for
> Invoices, and one for Receipts. That part works fine. Now I need to either
> create a fourth cube, or maybe somethings else, whcih allows me to comine
> the records of three fact tables into one view. I'll need specifcally six
> columns of each fat tables, which have been named the same, to be included
> in the new fourth cube.
> The issue is not to combine multiple fact tables into one cube. The issue,
> maybe, is to combine multiple fact tables into one fact table and then use
> that table in a cube.
> -G
>
> "Jeje" <willgart@.hotmail.com> wrote in message
> news:AB50D69A-F1BB-455D-88EB-63B8B4EE9A4E@.microsoft.com...
>

Joining cubes

I have three cubes in AS. How can I have a separate cube which can retrieve
data from these three cubes and then (similar to join function in T-SQL)
can join the results?
Thanks,
Gilgameshthere is no join option for cubes.
but you can use virtual cubes (in AS2000) or link the cubes (SSAS2005)
when you link 1 cube in another, the user is able to access the measures of
the 2 cubes at the same time.
you have to use shared/common dimensions to be able to analyze the measures
of the 2 cubes at the same time. (like 1 common time dimension)
"Gilgamesh" <gilgamesh4ever@.aol.com> wrote in message
news:ukwtRNGYHHA.1240@.TK2MSFTNGP04.phx.gbl...
>I have three cubes in AS. How can I have a separate cube which can retrieve
> data from these three cubes and then (similar to join function in T-SQL)
> can join the results?
> Thanks,
> Gilgamesh
>|||How do you share dimensions? I tried nameing them the same in all thecubes,
but when I drag and drop the dimensions to the browser it creates separate
columns even though they're called with the same name.
-G
"Jeje" <willgart@.hotmail.com> wrote in message
news:5E0F1674-B392-4739-82CE-2ED8657CF469@.microsoft.com...[vbcol=seagreen]
> there is no join option for cubes.
> but you can use virtual cubes (in AS2000) or link the cubes (SSAS2005)
> when you link 1 cube in another, the user is able to access the measures
> of the 2 cubes at the same time.
> you have to use shared/common dimensions to be able to analyze the
> measures of the 2 cubes at the same time. (like 1 common time dimension)
>
> "Gilgamesh" <gilgamesh4ever@.aol.com> wrote in message
> news:ukwtRNGYHHA.1240@.TK2MSFTNGP04.phx.gbl...|||do you use AS2000 or 2005?
is AS2000 shared dimensions are created in the shared dimension tree of the
management console.
use the SAME dimension in both cube to be able to analyze the measures of
the 2 cubes at the same time.
in 2005 all the dimensions are shared by default, so use the same dimension
in both cubes.
having the same name is not enough.
"Gilgamesh" <gilgamesh4ever@.aol.com> wrote in message
news:eH3aUcdYHHA.2316@.TK2MSFTNGP04.phx.gbl...
> How do you share dimensions? I tried nameing them the same in all
> thecubes, but when I drag and drop the dimensions to the browser it
> creates separate columns even though they're called with the same name.
> -G
> "Jeje" <willgart@.hotmail.com> wrote in message
> news:5E0F1674-B392-4739-82CE-2ED8657CF469@.microsoft.com...
>|||Ok. I'm getting very close. How can I combine three fact tables into one? In
other words, how can I JOIN them?
-G
"Jeje" <willgart@.hotmail.com> wrote in message
news:9234EA65-4AA3-4983-86E1-360F679BA035@.microsoft.com...[vbcol=seagreen]
> do you use AS2000 or 2005?
> is AS2000 shared dimensions are created in the shared dimension tree of
> the management console.
> use the SAME dimension in both cube to be able to analyze the measures of
> the 2 cubes at the same time.
> in 2005 all the dimensions are shared by default, so use the same
> dimension in both cubes.
> having the same name is not enough.
> "Gilgamesh" <gilgamesh4ever@.aol.com> wrote in message
> news:eH3aUcdYHHA.2316@.TK2MSFTNGP04.phx.gbl...|||well... joining 3 fact tables its different.
can you explain what are the 3 tables and the 3 associated cubes you have.
and the version of the tools (SQL2000 or 2005)
take a look at the foodmart sample or the adventure works sample to see how
different fact tables are combined into 1 cube.
"Gilgamesh" <gilgamesh4ever@.aol.com> wrote in message
news:O4gUZDfYHHA.3628@.TK2MSFTNGP02.phx.gbl...
> Ok. I'm getting very close. How can I combine three fact tables into one?
> In other words, how can I JOIN them?
> -G
> "Jeje" <willgart@.hotmail.com> wrote in message
> news:9234EA65-4AA3-4983-86E1-360F679BA035@.microsoft.com...
>|||I'm using AS2005. I started by creating three differentd data source views
and then created one cube for each view. i.e. one cube for Orders, one for
Invoices, and one for Receipts. That part works fine. Now I need to either
create a fourth cube, or maybe somethings else, whcih allows me to comine
the records of three fact tables into one view. I'll need specifcally six
columns of each fat tables, which have been named the same, to be included
in the new fourth cube.
The issue is not to combine multiple fact tables into one cube. The issue,
maybe, is to combine multiple fact tables into one fact table and then use
that table in a cube.
-G
"Jeje" <willgart@.hotmail.com> wrote in message
news:AB50D69A-F1BB-455D-88EB-63B8B4EE9A4E@.microsoft.com...[vbcol=seagreen]
> well... joining 3 fact tables its different.
> can you explain what are the 3 tables and the 3 associated cubes you have.
> and the version of the tools (SQL2000 or 2005)
> take a look at the foodmart sample or the adventure works sample to see
> how different fact tables are combined into 1 cube.
>
> "Gilgamesh" <gilgamesh4ever@.aol.com> wrote in message
> news:O4gUZDfYHHA.3628@.TK2MSFTNGP02.phx.gbl...|||ok, now I see
first use only 1 DSV and add all the tales used in this unique DSV; add the
correct relationship between fact tables and dimension tables.
after, create only 1 cube and 3 measure groups each one linked to the 3
tables;
now you have 1 cube with the measures from the 3 source tables.
the cube wizard will create everything for you if the DSV contains enough
information (ie good links).
again, take a look at the adv. works sample to see how this works.
if your tables come from 3 different database, and if you are not familiar
with SSAS, try to copy your tables into the same database to simplify your
project.
or use the linked servers + views, but try to have only 1 source database
for your cubes.
"Gilgamesh" <gilgamesh4ever@.aol.com> wrote in message
news:enT0ScoYHHA.4008@.TK2MSFTNGP05.phx.gbl...
> I'm using AS2005. I started by creating three differentd data source views
> and then created one cube for each view. i.e. one cube for Orders, one for
> Invoices, and one for Receipts. That part works fine. Now I need to either
> create a fourth cube, or maybe somethings else, whcih allows me to comine
> the records of three fact tables into one view. I'll need specifcally six
> columns of each fat tables, which have been named the same, to be included
> in the new fourth cube.
> The issue is not to combine multiple fact tables into one cube. The issue,
> maybe, is to combine multiple fact tables into one fact table and then use
> that table in a cube.
> -G
>
> "Jeje" <willgart@.hotmail.com> wrote in message
> news:AB50D69A-F1BB-455D-88EB-63B8B4EE9A4E@.microsoft.com...
>