How many joins allowed in SQL Server 2008?
+2
A:
The limitations for SQL Server are listed here
The number of tables per query is only limited by the amount of available resources.
Barry
2010-04-01 07:09:23
Thanks Barry for reply.
kandarp
2010-04-01 07:38:21
+3
A:
In SQL Server 2008, the maximum number of tables you can have in a SELECT is limited only by available resources (source).
In SQL Server 2005, there was a 256 table limit for a single SELECT (source).
Though, if you're getting up to those sorts of numbers, then I'd be getting a bit concerned tbh!
AdaTheDev
2010-04-01 07:12:03
"Raymond Chen notes that if you have to ask where the operating system limits are, you're probably doing something wrong" http://www.codinghorror.com/blog/2007/10/pushing-operating-system-limits.html
Jeff Atwood
2010-04-01 07:14:31
The only time I've ever seen anyone hit the limits was when they foolishly used views to call views which called views, etc. If you are using views to call views, it is time to stop now while your system is still functional (not only will you run into the limits, but you will have sever performance problems long before you run into the limits of waht can be called).
HLGEM
2010-04-01 13:51:32
A:
Hello All,
Wanted to know how many inner /outer joins is allowed in one query. like in mysql the limit is 61 tables that i can use in a single query? how about in ms sql?
"The number of tables per query is only limited by the amount of available resources." what do you mean by available resources?
Rima
2010-04-01 07:53:42