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:
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.
|
|
| |
