This was very helpful, especially the second article. Thank you kindly.

Flo, this will do the trick. Thank you for the input.

Steve, there are only 2 tables that are heavily deleted from and inserted into. those are the ones that would need any type of defragmenting on a somewhat regular...

Steve, what is the best way to schedule this say weekly? Is it best to use ALTER INDEX, DBCC DBREINDEX or some other method? Thank you.

I am using the batch method with 100000 row chunks and it is working very well. There is very little to no logging occurring. My question is with...

This will not work because select into will not give me the true definition of the table, specifically the division_id which is a computed column. I suppose I could...

Thank you for the explanation. That helps a lot. 🙂

-David

This is nice! Could you please provide a description of what the following columns mean:

user_seeks

system_seeks

user_scans

system_scans

user_lookups

system_looksups

user_updates

system_updates

score

What should I bee looking for here? What red flags should I look for?

Also,...

The primary key is actually on order_id, retailer_id and transition_seq. The situation is orders are stored by stores and a sequence. for some reason order ids are NOT...

David, thank you for the input. Being that this is just for SS 2005 + I am forced to use sp_who2 and DBCC INPUTBUFFER(spid).

I would like to use a...

Jeff, yes it was a CPR error. I have expressed the same concerns pertaining to using the shrinkdatabase command in this daily maintenance routine however the higher authorities insist...

Vj, excellent point. Thank you.

-David

Excellent! Thank you kindly.

-David

Yes you are correct. But this works fine.

DECLARE

@DBName VARCHAR(100),

@sql NVARCHAR(4000),

SELECT @sql = N'use ' +...

The WHERE database_id > 4 works fine.

Thank you Markus.

-David