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


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 2:47 AM
Points: 1,505, Visits: 1,064
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


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 5:48 PM
Points: 8,196, Visits: 9,893
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


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 4:01 AM
Points: 2,010, Visits: 2,498
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