Thanks guys!

to answer the quesiton, the IP doesn't resolve at all.

the linked table thing fits the problem perfectly!

thankyou

Gareth

It's defined using boundary points which split it over the physical files. I've checked and the data is residing on the appropriate physical files. For the specified boundary points.

The...

😀 I agree with you. I won't be able to gain additional funding for this project and my time is not billable, so its considered already paid for...

One simple question.

The main advantage of partitioning is the parellel processing you gain from it correct?

If so, then perhaps I need to make my partitions smaller so that multiple partitions...

Thanks for your replies guys.

After reading your responses I tried a few more things.

I've tried queries which will only query one partition they are slower.

I then wrote queries which will...

thanks Manu

Sorry should have said that as well.

Yes auto update stats and auto create stats are both on.

So if I ran a query like so:

select * from table1

where column1 =...

Anybody done any third party compression vs. sql2008 compression?

One thing we do is run the defrags outside peak hours and limit the run time.  So it builds a list of fragmented indexes, as per your job, then defrags them in...

I was afraid it might be something like that.  That's a real pain, I'd rather not hack the sp, but it is definitly better than making them SA.  Is their...

Think of a phone book.  The clustered index is the way the data is stored.  There is no difference between the data and the clustered index, the index is the...

Not sure of it's price, or if it's free or not, but we use sql zip extentisvly without problems...