You are creating a SQL Server 2005 database for a mortgage company. The database will support a new Web-based application that will handle up to 1,000 simultaneous users.
This application must quickly display the results of calculation-intensive operations, such as calculating mortgage payments and amortization schedules. You need to ensure that the database processes calculations as quickly and efficiently as possible. What should you do?
A.
Implement parameterized Transact-SQL queries in the application.
B.
Implement Transact-SQL stored procedures in the database.
C.
Implement CLR stored procedures in the database.
D.
Implement distributed Web services.
Explanation:
A Common Language Runtime (CLR) will generally perform better than T-SQL and CRUD (Create, Read, Update, Delete) operations for complex math, string manipulation and other tasks that go beyond data access.