Clustered Index:1
Non clusetered index: 999
xml index: 249
Fk's: 253
columns per FK, PK, index: 16
Databases, Filegroups, Files per instance: 32,767
Max DB size: 524272 TB
Instances per computer: 50 on satnd alone, 25 on failover
Max number of objects in a DB(views, procs, index,keys, triggers): 2,147,483,647 (Triggers are limited only by max no of objects)
For more details: http://msdn.microsoft.com/en-us/library/ms143432.aspx
No comments:
Post a Comment