Microsoft has just added support for query hints to Azure SQL Database, giving database administrators a powerful tool to manage the performance of ISV application code. Here's how it works.

Use SqlServerCmdletSnapin100 (installed when you install the SQL Server client tools, 2008 or newer (maybe 2005)) and it gets a lot easier.

Ok, I'm trying to write a query in a stored procedure in SQL Server 2000. Because some of the parts of the query vary based on certain situations I construct a string that contains the query and ...