Query hints apply to the whole statement through the OPTION clause. This primer from Joes 2 Pros Volume 3 covers the basics of a query hint.
SQL SERVER – Introduction to Hierarchical Query using a Recursive CTE – A Primer
A primer from Joes 2 Pros Volume 2: what a CTE is, how it compares to a derived table, and how to write a hierarchical query using a recursive CTE.
SQL SERVER – Installing AdventureWorks Sample Database – SQL in Sixty Seconds #010 – Video
Need sample data to try new SQL Server features safely? This SQL in Sixty Seconds video shows how to install the AdventureWorks sample database.
SQL SERVER – Cleaning Up SQL Server Indexes – Defragmentation, Fillfactor – Video
Cleaning up SQL Server indexes starts with fragmentation. Learn the two types, when to reorganize or rebuild, and how fillfactor fits in.
SQL SERVER – T-SQL Constructs – *= and += – SQL in Sixty Seconds #009 – Video
Vinod Kumar is back with T-SQL constructs in SQL in Sixty Seconds #009, showing how .NET developers can use familiar syntax like *= and += in T-SQL.
SQL SERVER – Using MAXDOP 1 for Single Processor Query – SQL in Sixty Seconds #008 – Video
Some queries run best on one CPU. In this sixty second video I show how to restrict such a query to a single processor with OPTION (MAXDOP 1).
SQL SERVER – Table Variables and Transactions – SQL in Sixty Seconds #007 – Video
Many developers expect a rollback to undo changes in a table variable. This sixty second video on table variables and transactions shows it does not.