Answer / vimalssssss

1.SQL server is more user friendly and takes less time to
install
2.A database administrator can manage comparatively more
number of SQL server databases than Oracle
3.SQL server also has advanced features like advanced
compression, data mining, partitioning, OLAP, enterprise
reporting included in the package, while businesses who use
Oracle servers have to purchase these features separately.

Answer / vimsssssssssss

1. A database administrator can manage over 65 critical SQL
server databases, where as the same administrator can
manage only 15 Oracle critical databases.
2. SQL server is more user friendly and takes less time to
install when compared to Oracle server.
3. SQL server also has advanced features like advanced
compression, data mining, partitioning, OLAP, enterprise
reporting included in the package, while businesses who use
Oracle servers have to purchase these features separately.

What are the triggers in sql?

0 Answers  

---

When we can say that is in BCNF?

3 Answers   BitWise,

---

Explain the architecture of ms sql reporting service?

0 Answers  

---

What is a view? is View updatable?

17 Answers   IBM, L&T,

---

What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

0 Answers  

---

---

What does <> symbol mean?

0 Answers  

---

Which institute is best for SQL Server 2005 Training?

6 Answers  

---

What are types of storage modes? : sql server analysis services, ssas

0 Answers  

---

Where are stored procedures in sql server?

0 Answers  

---

Display a roll having miminum marks in two subjects?

7 Answers   Patni,

---

Explain the difference between cross join and full outer join?

0 Answers  

---

if a parameter is not send to a stored procedure what type of identifier is to be used in Stp and if that parameter is not feed to the a query inside the Stp how to validate with out useing IF condition

1 Answers   Aviva,

---