Lowell (4/2/2013)

---

As Sean has identified, all we can offer is vague advice unless ou have some details we can look at to try and help.

here's a quick list of some things to look for, in general:

· How much Data is being returned? are there millions of rows, or columns with huge varbinary/image/varchar maxes being returned?·

· Are there clustered indexes on all the tables involved?

· Are there indexes to support the query?

· Is There a WHERE statement being used? if not...that's a table scan of all the data.

· Are there columns that are being selected that are not used (ie a VIEW of 50 columns, but you need only three columns)

· Are the statistics up to date?

· Are you using catch all queries?

· Are the WHERE statement parameters SARG-able?

· Are any functions being used in the WHERE statement?

· Are there any inline SELECT statements to get a a single or correlated value (i.e. ColumnName = (SELECT...)

· Could the Indexes benefit from INCLUDE columns?