A few months ago when I was working with Oracle in a data warehouse, I came across hints. Basically these are statements in the below form
/*+ hint */ /*+ hint(argument) */ /*+ hint(argument-1 argument-2) */
/*+ hint */
/*+ hint(argument) */
/*+ hint(argument-1 argument-2) */
select /*+ FULL(emp) PARALLEL(emp, 35) */ emp_name from emp;
SQL Server, or at least SQL 2008 does have that functionality. Read this http://technet.microsoft.com/en-us/library/ms187373.aspx for more information
seen it, thanx