Interested to Buy Any Domain ? << Click Here >> for more details...
why SQL server is more used to store database rather than
Access
- 2 Answers
- 4587 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
How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
what is a self join? Explain it with an example? : Sql server database administration
What is the difference between deallocate cursor and close cursor?
What is an index. What are the types?
What are the types of subscriptions in SQL Server replication?
What is the command used to recompile the stored procedure at run time?
explain different types of joins? : Sql server database administration
How do you start single user mode in clustered installations?
Explain what are the restrictions while creating batches in sql server?
Explain in brief about Microsoft SQL server?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
What is the need for indexing?
What is a View ? Can we insert, Update and delete a view?
