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.

Explain indexed views and partitioned view with their syntax.

0 Answers  

---

What happens if you insert a duplicate key for the primary key column in ms sql server?

0 Answers  

---

Can store procedure call by user define function in SQL server?

10 Answers   HCL,

---

What is the use of floor function in sql server?

0 Answers  

---

What should be the fill factor for indexes created on tables? : sql server database administration

0 Answers  

---

---

How to select some specific rows from a table in ms sql server?

0 Answers  

---

There is table like Events...in that name ,startdate ,enddate,location are the column names write a stored Procedure for this table to get events by Months "GetEventsByMonths"

2 Answers  

---

what is normalization? what is denormalization?

9 Answers   Satyam,

---

Does union all remove duplicates?

0 Answers  

---

What is the difference between stored procedure and user defined functions?

0 Answers  

---

What is sparse columns of sql server 2008?

0 Answers  

---

What is surrogate key? : sql server analysis services, ssas

0 Answers  

---