Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


why SQL server is more used to store database rather than
Access

Answers were Sorted based on User's Feedback



why SQL server is more used to store database rather than Access..

Answer / 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

why SQL server is more used to store database rather than Access..

Answer / anilreddy

Access can store only 2 GB of data where as in SQLSERVER 2005 one column can store more than 2 GB of data

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More SQL Server Interview Questions

How to write an inner join with the where clause in ms sql server?

0 Answers  


what authentication modes does sql server support? : Sql server database administration

0 Answers  


What is the difference between createstatement and preparedstatement?

0 Answers  


what are the different types of replication you can set up in sql server? : Sql server database administration

0 Answers  


What is measure group, measure? : sql server analysis services, ssas

0 Answers  






How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

3 Answers  


What is correlated subquery in sql server?

0 Answers  


What is repeatable read?

0 Answers  


What is the most common type of join?

0 Answers  


Explain Trigger with an example?

2 Answers  


How extra digits are handled with numeric data type literals?

0 Answers  


How many non clustered indexes there can be on table ?

0 Answers  






Categories