!! Saurabh's world of possibilities !!

Geek with eyes

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)

Published Thursday, December 30, 2004 2:23 PM by saurabhv

Comments

 

Vinod Kumar said:

December 30, 2004 2:54 PM
 

~Saurabh said:

Nice link.

Thanks for a precise link.
December 30, 2004 3:19 PM
 

Yavuz Bogazci's Blog said:

January 5, 2005 5:19 AM
 

Yavuz Bogazci's Blog said:

January 5, 2005 5:23 AM
 

google456 said:

January 24, 2005 10:33 AM
 

ar triggeres said:

June 4, 2008 7:45 PM
 

Saurabh s world of possibilities Powers of SQL Server | Cast Iron Cookware said:

June 3, 2009 3:37 PM
Anonymous comments are disabled

© 2009 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Microsoft
Page view tracker