Interested to Buy Any Domain ? << Click Here >> for more details...
why SQL server is more used to store database rather than
Access
- 2 Answers
- 4705 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
role of sql sever 2005 in database rather than any other database
What are indexes in sql?
What are extended events in sql server?
What is explicit mode in sql server?
What is row-level compre?
Which tcp/ip port does the sql server run on? How can it be changed?
How to set the current database in ms sql server?
Why normalization is used?
What are the differences between decimal and float in ms sql server?
How many primary keys are possible in a table?
How to create a view using data from another view?
What is the difference between writing data to mirrored drives versus raid5 drives
How are the unique and primary key constraints different?
What does it mean if @@cursor_row returns a negative number?
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
