You discover that the msdb database on a SQL Server 2005 computer is corrupt and must be restored. Databases are backed up daily. The database backup files are written to a network share, but the file names do not clearly indicate which databases are in each file. You need to locate the correct backup file as quickly as possible. The first file in the list is named DB_Backup.bak. Which Transact-SQL statement should you use?

You discover that the schema changes that were recently made to your SQL Server 2005 database have caused your Web site to stop functioning. It is unclear who made the changes.
Your company now mandates that all changes to the database schema be tracked. You need to implement a mechanism that will track schema changes in your database. What should you do?

Your SQL Server 2005 database contains a table that has 500 million rows of data. Some of the data is historical and some is current. You need to partition the data on a single server to increase performance and optimize maintenance.
What should you do?

You are responsible for managing a SQL Server 2005 database that stores sales information.

Many values in nchar columns in the database tables contain preceding or trailing spaces. You need to implement a mechanism that selects the data from the tables without leading and trailing spaces.
Your solution must be available for reuse in Transact-SQL statements and views. What should you do?

You are responsible for maintaining a SQL Server 2005 database. Business analysts in the company routinely use a view named v_CusMikeerSales to join the CusMikeers and Sales tables in the database.
They use the view to aggregate total sales by cusMikeer by month. You need to increase the performance of the view. What should you do?

You are modifying a table named Product in a SQL Server 2005 database. You want to add a new column named FriendlyName to the Product table. A friendly name for each product will be stored in this column.
The table currently contains data. The sales department has not yet created a friendly name for each product. FriendlyName is a required value for each product. You want to add this new column by using the least amount of effort. What should you do?

You are planning to import cusMikeer data from the CusMikeer table and the Country table in your SQL Server 2000 database into a SQL Server 2005 database.
You want to ensure that during the import process, each value in the CountryCode column of the CusMikeer table has a corresponding record in the CountryCode column in the Country table of the SQL Server 2005
database. You define a foreign key between these two tables

Thus, referential integrity will guarantee that the import routine fails if there are any records where a CountryCode value does not exist in the Country table but does exist in the CusMikeer table.
You need to ensure that the import process does not fail if records are encountered that do not exist in the Country table.
What should you do?

Your company has a server named SQL1 that runs SQL Server 2005 Enterprise Edition. SQL1

has 2 GB of RAM, 1.6 GB of which are used by the default SQL Server database engine instance. The average data growth of all databases combined is 100 MB a month.
Users state that report execution times are increasing. You want to assess whether more RAM is needed. You need to use System Monitor to create a counter log that will help you decide whether to add RAM. Which performance object should you add to the counter log?

Your company has a server named SQL1 that is dedicated to SQL Server 2005. SQL1 is configured for SQL Server and Windows Authentication mode. Using Windows Authentication, you have sysadmin privileges on SQL1.
All users who work with SQL1 report that all applications that use SQL1 stop responding. Your supervisor asks you to investigate the problem. In Task Manager, you notice that CPU usage is at 100 percent.
You try to connect to SQL1 by using SQL Server Management Studio. SQL1 does not respond. You need to connect to SQL1 to diagnose the problem. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)

Your database named DB1 is one of 15 databases located on a SQL Server 2005 computer named SQL1. Recently, users who work with DB1 report that they experience long query execution times.
You want to reproduce and analyze this problem in a test environment that holds all copies of the production databases.
You need to record the workload for an entire day on SQL1 for later execution on the test server.
You must ensure that all events are captured without skipping any, even if SQL1 is under stress. What should you do?