I agree with you antares unless there has been deletes on the table as heaps reclaim empty space

Make sure you do not have auto-shrink on as it will lead to this problem. The percentage of MB growth depends on your level of need, if your db is...

I would also argue that it depends on too many things to say when a nonclustered index will be used when doing a "select *", I would argue that it...

Whoa, I think a lot of stuf flying around here.

Does a nonclustered index have to be covering to be used? - No

"Since there is no clustered index on this...

It is not using the nonclustered index becuase you are returning everything. When you do select *, it would make no sense for it to go to the nonclustered index,...

To add to James's post, watch where you place that clustered index, placed on the wrong type of column and you will get additional pagesplits as SQL tries to insert...

See if this helps - http://sqlteam.com/item.asp?ItemID=2955

A cube would be a piece of cake to create for this and you have full flexibility with X and Y axis.

Have you already ran at least one full processing yet? If yes, have you recently changed the structure of any dim tables? I would try to run a full process,...

I agree with raibeart to a point, I would try to use star schema as much as possible but there are certain times...

"delete from tbl1 where pid not in (select max(pid) from tbl1)"

Wouldn't that delete all rows exept the one with the max PID?

Do you mean going forward or historically? You might look into a product by Lumigent called Log Explorer or Entegra.

Going forward you could work some magic with SQL Profiler.

I agree with all in that if you are write heavy and query-light, scsi is the way to go, however, if you are having to perform complex analysis or queries,...

If you are transferring the whole db, I would not use DTS, I would use T-SQL jobs to do backup and restore. If they are on seperate machines you could...

I was trying to convey that was a bad thing alzdba, I should have mentioned I agreed with you too. Anytime SQL has to perform a lot of logic before...

I agree with Colin. Since 7.0 heaps were built to reclaim space, that means SQL will hunt out free space and try to insert new data where a page has...