I have some Crystal SQL command object reports which need to be optimized to run on a huge MS SQL Server database. The reports take too long to run. I know how to use the Oracle Explain plan utility to see the statistics of the query load on the database. Is there a similar MS SQL utility which will help me determine how to modify my queries for optimum performance (to run faster). Thank you in advance for your input.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.