why SQL server is more used to store database rather than
Access
- 2 Answers
- 3896 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
Explain sql delete command?
Define tool Manage Statistics in SQL Server 2000 query ?
What is repeatable read?
How to return the second 5 rows in ms sql server?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
What is data source document?
How can you insert null values in a column while inserting the data?
Explain the phases a transaction has to undergo?
What is RAID? What are the different types of RAID configurations?
What is report server project?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
What is dirty read?
What is create command?
What is store procedure?
What is fill factor and pad index?
