what are the main differences between ms access and sqlserver
Answer / 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 |
How can I check if a view exists in a sql server database?
in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration
Explain what are the basic functions for master, msdb, model, tempdb databases?
How many types of attribute relationships are there? : sql server analysis services, ssas
Explain about system database?
What is the security principal at the server level that represents your session?
What are null values in ms sql server?
Can we insert data if clustered index is disabled?
Can group by be used without aggregate functions?
What is row by row processing ?
What is RMS migrations?
Explain the working of sql privileges?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)