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 ...

The new time series engine is capable of responding to queries faster, supporting data analysis of massive database workloads.