Powers of SQL Server

Do you know you can have:

1. 32,767 database per instance of sql server
2. 2 billion tables per database
3. 1024 columns per table
4. 65,535 secondary datafiles per database
5. 256 filegroup per database
6. bytes per row - 8060
7. clustered index per table - 1
8. columns per index - 16
9. columns per select statement - 4096
10. files per database - 32,767
11. maximum file size of data - 32 TB
12. nested subqueries, transactions, Stored Procedures, triggeres - 32
13. rows per table - limited to storage space
14. tables per select statement - 256
15. Non clustered index - 249

(thanks to my friends for their contribution)

Comments

• Anonymous
  December 30, 2004
  Find this information at: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_51wz.asp
  
  Vinod

• Anonymous
  December 30, 2004
  Nice link.
  
  Thanks for a precise link.

• Anonymous
  January 24, 2005
  [http://www.vbzx.net/ vb]
  [http://www.kedacom.com/ 视频会议]
  [http://www.actrip.com/ 海南]
  [http://www.google456.com/ google排名]
  [http://hxairlines.com/ 飞机票]
  [http://www.huojiawang.com/ 货架]
  [http://www.houseso.cn/ 租房]
  [http://www.artmtm.com 包装设计]

• Anonymous
  June 04, 2008
  PingBack from http://elliana.rightnewsdigest.info/artriggeres.html

• Anonymous
  June 03, 2009
  PingBack from http://castironbakeware.info/story.php?title=saurabh-s-world-of-possibilities-powers-of-sql-server