Beauty of Database - SQL Server |
| |
|
|
|
New Coder Posts: 49 Topics: 14
|
|
|
September 15, 2008, 06:38:28 AM
|
|
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
« Last Edit: September 04, 2009, 01:40:32 AM by Admin »
|
|
| |
|
|
|
Code Guru Gender:  Posts: 1399 Topics: 85
|
|
|
January 06, 2009, 06:15:46 AM
|
|
Surely all of this depends on the database implementation? I.e. MySQL will be dififerent from postgre, which are different from access etc....
Having said that, yes, databases are the bred and butter of the internet - chances are this information is held in a database (admin will need to tell us what sort, would guess MySQL though.)
|
|
| |
|
|
|
New Coder Posts: 16 Topics: 7
|
|
|
July 20, 2010, 10:09:22 PM
|
|
interesting information, thanks
|
|
| |
|
|
|
Skilled Coder Posts: 125 Topics: 0
|
|
|
February 21, 2011, 02:48:48 AM
|
|
Really very nice information shared by you.
|
|
| |
|
|
|
New Coder Posts: 25 Topics: 1
|
|
|
March 28, 2011, 08:31:39 AM
|
|
Nice information all key terms in nutshell. Thanks for sharing
|
|
| |
|
|
|
Skilled Coder Real name: Janne
Location: california
Gender: 
Age: 26
Posts: 108 Topics: 1
|
|
|
May 11, 2011, 11:43:32 PM
|
|
this is a real beauty of the database......good to know abt it.......
|
|
| |
|
|
|
Professional Coder Posts: 229 Topics: 7
|
|
|
July 21, 2011, 01:53:41 AM
|
|
yes its very nice things about sql server, its very exciting me. Thanks.
|
|
| |
|
|
|
New Poster Posts: 6 Topics: 0
|
|
|
August 24, 2011, 02:11:41 AM
|
|
wao, that looks really very awesome ,thanks for sharing.
|
|
| |