You work as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. The Domain.com network contains a SQL Server 2005 database server named Certkiller -DB01. Your duties include administrating Certkiller -DB01. Certkiller -DB01 is hosting Domain.com’s commercial Web sites. You are creating a database on Certkiller -DB01 to support a new Web-based application that will handle up to 2,000 simultaneous users. The application that will access this database must quickly display the results of calculation-intensive operations. You need to ensure that the database processes calculations as quickly and efficiently as possible.
What should you do?
A.
You need to implement parameterized Transact-SQL queries in the application.
B.
You need to implement Transact-SQL stored procedures in the database.
C.
You need to implement CLR stored procedures in the database.
D.
You need to 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.