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
--