This is SQL Express, a free version. There are some limitations.

I see a manchine with 7 GB RAM available. Yet I get the idea SQL is not using...

Hi Jeff,

I still think we're talking about different things here. I don't see how partitioned views in SQL 2000 are going to help (I have experience with partitioned tables...

Database partitioning is not my first thought, and I think partitioning didn't work in SQL 2000 like we're used to now. I have cleaned out a SQL 2005 database...

The reason why Ola Hallengren's solution is better than the DBCC REINDEX commands:

- Microsoft recommends doing a reorganize only when fragmentation > 5% and < 30% and even do nothing...

After doing a shrink, also rebuild your indexes, as they will probably be invalidated by the shrink.

I don't do a shrink often, but in this case it was a valid...

+1 for Ola Hallengren.