Thank's a lot Lowell.

Rectification: The indexes were not rebuilt at all. They were rebuilt only in another database. It was a mistake. So the fact that the DBCC SHRINK DATABASE worked is not...

I am not 100% sure but I think that having rebuild all the indexes help us to shrink the database with this command:

DBCC SHRINKDATABASE(N'BIG_DB')

At the end, without the option to...

Steve Jones - SSC Editor (9/15/2015)

---

Get faster disks. I don't know a better way to do this.

You could maybe create a new filegroup, move the table, then shrink the...

I Gail,

The index rebuild did not help for this command:

DBCC SHRINKFILE (N'big_db' , 0, TRUNCATEONLY)

But instead, I found that using this command was actually shrinking the file:

DBCC SHRINKFILE (N'big_db' ,...

Thank's for your input Alvin.

Querying the star schema will be one of our tests but we expect it to be way much slower than querying the cube with MDX.

Best regards.

Carl

Thank's for your answer PB_BI.

Best regards.

Carl

"Is it possible to have a MDX query that restrict (WHERE CLAUSE) based on a column's value that is in a fact table?"

Lets give an example:

Lets say we want to...

This also permit us to include conversion scripts that only modify the data (DML not DDL) which I don't know how this would be done with the other method (State).

Hi Steve,

We are upgrading all our databases with migration scripts. We implement it in a way that the tool (that is used to run the conversions) knows which conversion scripts...

To be more precise I should have wrote:

... if we can avoid rebuilding...

Hi Sean,

It would be simpler to process all the tables. But let's say you can avoid rebuilding indexes on 5 to10 really big tables, it would reduce a lot the...

Yes it is.

Hi Gail,

Yes. The contexte is the following :

Application upgrade with a...

ScottPletcher (11/6/2013)

---

2. That's an extremely tricky thing to try to do. You could try to analyze the avg_fragmentation_in_percent, max_record_size_in_bytes and avg_record_size_in_bytes values from sys.dm_db_index_physical_stats, but it will still...