then you should DROP these indexes.

Great job!

One more fix:

SELECT REPLACE(REPLACE(sch.name + '_' + t.name, '[', '_'), ']', '_') AS [tname] ,

' update statistics ' + QUOTENAME(sch.name)...

Very-very bad advice. 20% of 128GB is 25Gb, are you sure you want to allocate so much memory for OS?

http://www.dundas.com/

ben.brugman (1/22/2013)

I do not think normal disk IO (SAN) can...

I believe that the index you created is far away from perfect.

First you need to find the most selective condition, please post the results of the following queries:

DECLARE @CustAccount varchar(20),

@PriceDate...

It looks like cardinality estimation error. Please update statistics WITH FULLSCAN on DataSource and Trade tables.

Also in the original query you can try to replace

INNER JOIN dbo.DataSource ON dbo.DataSource.DataSourceID=dbo.Trade.DataSourceID ...

Very stupid advice.

What part of the error message you don't understand?

Why do you need it?

What part of the message you don't understand?

You have to put CreatedDate into keys of your index.

As 2 LEFT JOINs to the same ZipCodes table.

http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html

Do you mean that it useful when you want to create script with unpredictable result? Sure it is.

Estimate the Size of a Full Database Backup

Before you implement a backup and restore strategy, you should estimate how much disk space a full database backup will use. The backup...