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
- 13461 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
How will you find out if there are expensive SQL statements running or not?
Can a function call a stored procedure in sql server?
Explain the properties of the relational tables?
Can you explain full-text query in sql server?
What is the syntax for encrypting a column in SQL Server?
Can I work with several databases simultaneously? : sql server management studio
How do we synchronize On-Premise SQL server with SQL Azure?
Mention the differences between having and where clause.
What is sql sandbox in sql server?
What happens to a trigger with multiple affected rows?
What is dirty page?
What is clustered index
It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio
Can group functions be used in the order by clause in ms sql server?
Explain what role entity and relationship play in an ER diagram.
