Answer Posted / santosh kumar sharma

You can encapsulate your business logic in SP. Easy to
maintain as any changes in the business logic, you'll just
have to alter the SP and not your application.

List layers of abstraction microsoft architectured to provide relational db through cloud platform ?

183

---

What is the use of nvl work?

1009

---

What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

2762

---

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

914

---

Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

120

---

between cast and convert which function would you prefer and why?

957

---

What is the maximum size of a row in sql server?

969

---

What are the steps to take to improve performance of a poor performing query? : sql server database administration

1057

---

How to create a simple stored procedure in ms sql server?

1032

---

Give main differences between "Truncate" and "Delete".

1100

---

Why olap is used?

977

---

Write a query for primary key constraint with identity key word?

1031

---

How to make conditional sum in ssrs?

177

---

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

912

---

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

2071

---