You are a database administrator for AIOTestKing.com. You are responsible for a SQL Server 2005 database that has several indexes. You need to write a stored procedure that checks the indexes for fragmentation. Which Transact-SQL statement should you use?

You are a database administrator for AIOTestKing.com. Your SQL Server 2005 computer contains one user database that holds sales transaction information. Users report that the queries and stored procedures that they use every day are taking progressively longer to execute. You also notice that the amount of free disk space on the SQL Server computer is decreasing. You need to create a maintenance plan to correct the performance and storage problems. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)

You work as DBA at AIOTestKing.com. You administer two Windows Server 2003 computers named AIOTestKing A and AIOTestKing B. You install SQL Server 2005 on both AIOTestKing A and AIOTestKing B to host a new company database. AIOTestKing A hosts a read-write copy of the company database in which all changes are made. AIOTestKing B subscribes to a publication on AIOTestKing A and is only used for reporting. A Windows domain administrator provides you with a domain user account named SQLSRV to use as the security context for the SQL Server services. A password policy of 42 days exists in the Default Domain Group Policy object (GPO). You install the database on AIOTestKing A and AIOTestKing B and configure replication. Everything works fine for six weeks, but then all SQL Server services fail. You need to correct the problem. What should you do?

You are a database administrator of two SQL Server 2005 computers named AIOTestKing A and AIOTestKing B. You have a Microsoft .NET application that has been modified so that it now accesses a database on AIOTestKing B in addition to AIOTestKing

You are a database administrator for AIOTestKing.com. Your company uses a different company’s application that is based on SQL Server 2005 Standard Edition. The application executes a query that uses an index query hint. The index query hint is not suitable for your environment, but you cannot modify the query. You need to force the application to use a different query execution plan. What should you do?