Good morning,

Need some help with the following MS SQL/DBA Questions:

- Describe the performance impact of using the LIKE operation with a wildcard character at the beginning of the value.

- Under what circumstances is a non-matching index scan performed?

- A query is written to access a single table. Furthermore, that query will return only a single row because an equality predicate is coded on the primary key for the table. A unique index exists to support the primary key. What type of access is likely to be the most efficient for that query?

- How can stored procedures be used to optimize performance in a client/server application?

- Under what circumstances will a table scan outperform indexed access?