Interested to Buy Any Domain ? << Click Here >> for more details...
What are the advantages of using sql server over ms access
or why should one use sql instead of ms access
- 2 Answers
- 13591 Views
- CMS, Impetus, I also Faced
- E-Mail Answers
Answer Posted / ramakrishna
Some SQL Server 2000 and Access 2000 products limits:
Feature SQL Server 2000 Access 2000
database size 1,048,516 TB 2 GB plus
linked tables size
objects in a database 2,147,483,647 32,768
user name length 128 20
password length 128 14
table name length 128 64
column name length 128 64
index name length 128 64
Number of concurrent users limited 255
columns per table 1024 255
table size limited 1 GB
number of indexes in a table 250 32
number of columns in an index 16 10
bytes per row 8060 2000
number of tables in a query 256 32
columns per SELECT statement 4096 255
nested subqueries 32 50
number of enforced relationships 253 32
| Is This Answer Correct ? | 24 Yes | 6 No |
Post New Answer View All Answers
What are cursors stored procedures and triggers?
What are the differences between clustered and non-clustered index?
How to count groups returned with the group by clause in ms sql server?
Explain what is sql server english query?
Can You Use Data Mining Models In Ssrs?
Why Master database is required?
Do you know exporting and importing utility?
What happens if null values are involved in string operations?
What is dimension table? : sql server analysis services, ssas
What is the syntax to execute the sys.dm_db_missing_index_details?
Explain table valued parameters in sql server? Why tvp used?
optimization techinques
How to write character string constants or literals in ms sql server?
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
How to perform backup for certificates in sql server? : sql server security
