You work as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Your duties include administrating a SQL Server 2005 database named Certkiller -DB04. You have received instruction from the CIO that Certkiller -DB04 will support a new Web-based application. This Web-based application will handle approximately 1,500 users simultaneously. The application must display the results of calculation-intensive operations like calculating the instalment and amortization schedules as quick as possible.
What should you do?
A.
You should implement the USE Master Transact-SQL statement.
B.
You should implement CLR stored procedures in the database.
C.
You should implement parameterized Transact-SQL queries in the application.
D.
You should implement Transact-SQL stored procedures in the database.
E.
You should 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.