Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Views Expand / Collapse
Author
Message
Posted Tuesday, January 5, 2010 12:19 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, October 24, 2014 6:41 AM
Points: 1,402, Visits: 1,008
j.summers (1/4/2010)
Books OnLine for 2008:
Tables per SELECT statement : Limited only by available resources


Thank you very much for sharing this observation.

Best regards,
Henrik



Post #841879
Posted Saturday, April 17, 2010 5:47 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 3:10 PM
Points: 7,814, Visits: 9,563
This is one of those cases where MS contradicts itself, BoL says in one place that the limit is 256 and in another place that there it's limited only be available resources. That makes it a fun question.

http://msdn.microsoft.com/en-us/library/ms177634.aspx says there's a limit of 256.
http://msdn.microsoft.com/en-us/library/ms143432.aspx says "Limited only by available resources".

And when I went to click on 256 I somehow clicked on 32. Looks like I'm as careless as MS is!


Tom
Post #905502
Posted Saturday, November 3, 2012 3:06 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 2:47 AM
Points: 1,926, Visits: 2,352
Nice Question..


_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1380688
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse