Interested to Buy Any Domain ? << Click Here >> for more details...
what are the main differences between ms access and sqlserver
- 1 Answers
- 4890 Views
- C DAC, CDAC, I also Faced
- E-Mail Answers
Answer Posted / appu
Access is installed as part of the Microsoft Office suite.
SQL Server can be quite expensive.
Access is more suited for desktop use with a small number of users accessing it simultaneously. One reason you might choose to use Access over SQL Server is for compatibility/sharing.
SQL Server was designed to have many hundreds, or even thousands of users accessing it at any point in time.
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
What is a trace frag? Where do we use it?
Is it possible to update the views? If yes, how, if not, why?
What are system databases into sql server (2005/2008) : sql server database administration
What happens when converting big values to integers?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
Differentiate between mongodb vs. Sql server?
Explain isolation levels that sql server supports?
Can you explain different types of locks in sql server?
Write a sql query to delete duplicate records from a table called table1
Explain what are various ways to enhance the ssrs report?
When columns are added to existing tables, what do they initially contain?
How can I track the changes or identify the latest insert-update-delete from a table?
What is the difference between having clause and where clause in sql server?
Do you know the policy based administration feature of sql server 2008?
