You can do this on any of your SPs that use views; just replace the view reference with the select statement from the view. I know it doesn't make sense...

Is your report configured to use the incoming parameter? Is your data source configured to use the mapped report param?

Have you tried disabling the indexes prior to the insert; then enabling them once inserted? This should provide a significant boost.

It also depends on how much data will be returned. Usually when a lot of data will be returned it is faster to do a scan (even a table scan)....

Full text is good for when you have searches with the wild card prior to any text. When this happens it causes SQL Server to do a full scan on...

You may not actually have a problem. If the majority of the resources are used in the ORDER BY clause and the ordered column is using a non-clustered index, it...

Our team has actually avoided using views altogether. Time and time again, you can take the same SQL statement from a view and use it in the SP (instead of...

Yihong,

You stated your query in a Data Warehouse uses 8 tables joined together. Usually the DW queries are denormalized to a point where very few joins are used. Is there...

Alex,

Are the tables in your FROM clause ordered correctly? One thing that I've noticed is that not a lot of folks are aware that you start listing the tables in...