Interested to Buy Any Domain ? << Click Here >> for more details...
why SQL server is more used to store database rather than
Access
- 2 Answers
- 4573 Views
- I also Faced
- E-Mail Answers
Answer Posted / murtaza
1.sql server supports Relational database Management Systems
whereas access does not support all the features of RDBMS.
2.sql server 2005 supports partitioning,bcp utility,Data
transformation services(DTS),SSIS which r not supported by
access
3.sql server 2005 supports crystal reports for reporting
services and can be use as an BI tool for OLAP Queries
access does not support crystal reports and does not support
BI tool.
4.sql server supports more large and mid size data processing
and access does not support volumnous data.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Is it possible for a stored procedure to call itself or recursive stored procedure?
What is use of except clause? How does it differ from not in clause?
Tell me what is fill factor?
List out the different types of locks available in sql server?
What is checkpoint in sql server?
What is acid properties?
What is the ‘fillfactor’?
How can you start sql server in different modes?
Explain sql delete command?
Describe the functionalities that views support.
What action plan is preferred if sql server is not responding?
Explain Geography datatype in SQL Server
Do you know the policy based administration feature of sql server 2008?
Explain activity monitors
Explain the properties of the relational tables?
