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.

Can we create clustered index on non primary key column

20 Answers   ABC, CTS,

---

sql database suspect We have a sql database that is showing as suspect. How can we recover?

0 Answers  

---

What is trigger in salesforce?

0 Answers  

---

what is an sql server?

1 Answers  

---

Does an index slow down updates on indexed columns?

0 Answers  

---

Explain the use of containers in ssis and also their types?

0 Answers  

---

How each E-R model constructs can be mapped to the relational model?

0 Answers   HCL,

---

difference between select column name from table name where serviceid=2; and select max(column name) from table name where serviceid=2; IN ORACLE

3 Answers   Intel, Wipro,

---

How will you fine tune a stored procedure or what are the steps that should be taken to fine tune or optimize a stored procedure?

1 Answers   Logitech, Mphasis,

---

is there more the two primary key in a single table?

26 Answers   Eforce, Systematix,

---

How will you optimize a stored procedure optimization?

0 Answers  

---

How to use "begin ... End" statement structures in ms sql server?

0 Answers  

---