why SQL server is more used to store database rather than
Access
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
How can you insert null values in a column while inserting the data?
What are different types of schemas?
Can we write trigger for view?
What are sub reports and how to create them?
What are constraints in microsoft sql server?
What are trace flags and mention a few common trace flags used with sql server?
How many types of the database links?
What is the full form of ddl?
What are difference between Cluster index and Non-Cluster index?
What are the differences between left join and inner join in sql server?
How to get a list of columns in a view using "sys.columns" in ms sql server?
What is tempdb database? : SQL Server Architecture
What is the architecture of ms sql reporting service?
Explain cdc and sql injection?
can a database be shrunk with users active? : Sql server administration