Hi,

If you use a variable in the query, the optimizer can't predict the runtime value, so it won't know which partition to access, thus optimizer will include all the partitions....

Hi,

Yep, this is the default behavior of SQL Server 2005, as you have already discovered.

Great result!

Thanks,

Phillip Cox

MCITP - DBAdmin

Hi,

I may be missing some of the post, but from what I have been able to read, sounds like this may be disk subsystem related. What is your backup...

Hi,

This code works perfectly and hits only the required partition:

DECLARE @COBDate SMALLDATETIME

DECLARE @sql VARCHAR(8000)

SELECT @COBDate = '20080208'

SELECT @sql = 'SELECT COBDate,Account,SUM(Amount) AS Amount FROM uv_rules WHERE...

Apologies for repeat post, formatting not correct.

Hey,

Ok, I have been able to re-create this issue.

So, just be sure I understand:

1. Your requirement is daily partitions?

2. You will load data into each daily partion on the date...

Hey,

Ok, I have been able to re-create this issue.

So, just be sure I understand:

1. Your requirement is daily partitions?

2. You will load data into each daily partion on the date...

Hey,

Ok, I have been able to re-create this issue.

So, just be sure I understand:

1. Your requirement is daily partitions?

2. You will load data into each daily partion on the date...

Hey,

Ok, I have been able to re-create this issue.

So, just be sure I understand:

1. Your requirement is daily partitions?

2. You will load data into each daily partion on the date...

Hey,

You will need to add an index on the COBDate column as well, as this forms one of your filters or SARG's. In terms of the original problem with...

Hey,

You will need to add an index on the COBDate column as well, as this forms one of your filters or SARG's. In terms of the original problem with...

Great result and its been a pleasure.

Thanks,

Phillip Cox

MCITP - DBAdmin

Hi,

No worries at all, glad I could help!

Here are a couple of documents covering both SQL Server 200 and SQL Server 2005, which will help you tidy-up. Once done,...

Hi,

Has SQL Server ever been installed on this pc? I would check registry under LocalMachine\Software\Microsoft to be 100% sure.

Thanks,

Phillip Cox

MCITP - DBAdmin

Hi Mike,

Please let us know the outcome of Redgate restore, but in the mean-time, still thinking.

Cheers,

Phillip Cox

MCITP - DBAdmin