Yes to some extent.
You can use locking hints to change the way that SQL Server locks the tables. You can use execution plan hints to change the way that SQL Accesses the table by forcing it to use a specific index.
If you want to you can statically set an execution plan into the plan cache for a specific query so that it always uses your plan. This is called pinning the plan and is new in SQL Server 2005.
REGISTER or login: