maximum joins

hello,
is there a restriction how many joins a query can have?
I am asking, because we have a query generator and probably we
will reach such a limit.
we have a star design.
one table in the center and probably thousand around this center table.
now we need to join theses tables generically.
thank you.
michael
256
http://www.aspfaq.com/2345
http://www.aspfaq.com/
(Reverse address to reply.)
"Michael Zdarsky" <zdarsky@.zac-it.com.(nospamplease)> wrote in message
news:D3F4C674-D21D-4CE2-B183-8A48B3D5D4F4@.microsoft.com...
> hello,
> is there a restriction how many joins a query can have?
> I am asking, because we have a query generator and probably we
> will reach such a limit.
> we have a star design.
> one table in the center and probably thousand around this center table.
> now we need to join theses tables generically.
> thank you.
> michael
>
|||According to Books Online the limit is 256 tables per query (can't say I've
ever put this to the test).
By "star design" do you mean a dimensional star schema? If so, you may want
to rethink what you are trying to do. There doesn't seem much point creating
a star schema if you want to do relational queries which then become so
complex. 1000 dimension tables seems pretty exceptional too!
David Portas
SQL Server MVP

maximum joins

hello,
is there a restriction how many joins a query can have?
I am asking, because we have a query generator and probably we
will reach such a limit.
we have a star design.
one table in the center and probably thousand around this center table.
now we need to join theses tables generically.
thank you.
michael256
http://www.aspfaq.com/2345
http://www.aspfaq.com/
(Reverse address to reply.)
"Michael Zdarsky" <zdarsky@.zac-it.com.(nospamplease)> wrote in message
news:D3F4C674-D21D-4CE2-B183-8A48B3D5D4F4@.microsoft.com...
> hello,
> is there a restriction how many joins a query can have?
> I am asking, because we have a query generator and probably we
> will reach such a limit.
> we have a star design.
> one table in the center and probably thousand around this center table.
> now we need to join theses tables generically.
> thank you.
> michael
>|||According to Books Online the limit is 256 tables per query (can't say I've
ever put this to the test).
By "star design" do you mean a dimensional star schema? If so, you may want
to rethink what you are trying to do. There doesn't seem much point creating
a star schema if you want to do relational queries which then become so
complex. 1000 dimension tables seems pretty exceptional too!
David Portas
SQL Server MVP
--