Your company uses a SQL Server 2005 database. This database contains a trigger named trg_lnsertOrders, which fires when order data is inserted into the Orders table.
The trigger is responsible for ensuring that a cusMikeer exists in the CusMikeers table before data is inserted into the Orders table. You need to configure the trigger to prevent it from firing during the data import process.
You must accomplish this goal while using the least amount of administrative effort. Which two Transact-SQL statements can you use to achieve this goal? (Each correct answer presents a complete solution. Choose two.)

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?

Your company Web site includes a page that cusMikeers use to send feedback about the company and its products. You use a SQL Server 2005 database to store the comments in the Comments column of a table named Feedback.
You need to implement full-text searching so that you can run reports on the comments. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

You are responsible for managing the database schema for an order entry application in a SQL Server 2005 database. After a design review, a member of the development staff asks you to add a new column named CommissionRate to the Product table.
Because the actual commission rates for all products are not known at this time, each product has a default commission rate of 12 percent. The rate can be modified as necessary.
You add the new column. You need to configure the table to assign the default value as efficiently as possible. What should you do?

You are responsible for implementing maintenance jobs on a SQL Server 2005 database server. Certain jobs run every Sunday and other jobs run at the beginning of every month.
You need to schedule the jobs in the way that uses the least amount of administrative effort. What should you do?

Your company uses SQL Server 2005. Users report that report execution is slow. You

investigate and discover that some queries do not use optimal execution plans.
You also notice that some optimizer statistics are missing and others are out of date. You need to correct the problem so that reports execute more quickly. Which two Transact-SQL statements should you use? (Each correct answer presents part of the solution. Choose two.)

A support engineer reports that inserting new sales transactions in a SQL Server 2005 database results in an error. You investigate the error. You discover that in one or the databases, a developer has accidentally deleted some data in a table that is critical for transaction processing.

The database uses the full recovery model. You need to restore the table. You need to achieve this goal without affecting the availability or other data in the database. What should you do?

You are moving a SQL Server 2005 database named Timesheet to a new database server. The Timesheet database is used by the TimeEntry application.
You need to minimize the amount of time that the TimeEntry application is unavailable while you move the database. What should you do?

You configure a new SQL Server 2005 computer to use TCP/IP with all default settings. Your

corporate policy requires that each server use a firewall. You find that you can connect to the SQL Server instance from the local computer. However, client computers cannot connect to the SQL Server instance.
You need to identity the most likely cause of the connection issues. What should you do first?

Your company has two SQL Server 2005 computers named SQL1 and SQL2. A user in your company named Eric writes many ad hoc queries against the company databases. Eric has access to the CusMikeer database on SQL1.

He does not have access to the Sales database on SQL2. You need to ensure that Eric can write queries that join information from both servers.
What should you do first?