For the 70-431 (MCTS SQL Server 2005) exam

Exam 70-431 MCTS SQL Server 2005 is one of the more popular exams and one of the certifications that always comes high in the list of most desired certifications.

Installing and Configuring SQL Server 2005

In order to change collation settings, reinstall SQL Server 2005 on a server with the same collation settings as another server.

In order to install SQL Server 2005 on a computer on which SQL Server 2000 is already installed, install SQL Server 2005 as a named instance.

Members of db_access role can assign permissions to other users to enable them to access and query the database.

Supporting Data Consumers

The TOP WITH TIES option can be used only with the SELECT ORDER BY clause.

The WITH TIES option can be used to retrieve those rows that are based on a given criterion.

In order to change the collation setting for an existing database, the ALTER DATABASE statement is used.

In order to perform the search operation in a database, use the WHERE clause with the SELECT statement.

The LEFT OUTER JOIN is used as follows:

SELECT FROM Order o LEFT OUTER JOIN OrderDetails od ON o.OrderID=od.OrderID

If the HAVING clause is used without the GROUP BY clause,it acts as a WHERE clause. This clause can be used to search records based on aggregates.

A word about simulations. It is possible to get full marks in the questions and not so good in the simulations and still fail because you did not demonstrate the knowledge. Don not let this deter you, as for most people the simulations are easier than the questions because they provide a visual reference.

You can click the follow links for referrences:642-972 xk0-002 000-331 642-072 650-621 642-061