I am a SQL Server DBA and have just started working with SAP. They say Microsoft recommends NOT running DBCC DBREINDEX regularly which I would like to do to reduce fragmentation (all 8,800+ table have a CI). They also state that it may cause corruption if it is run in a cursor.
I have a stored procedure that uses a cursor to get the table names and runs DBREINDEX and have had no problems.
Does anyone know of problems with DBREINDEX?
If there is a problem, where can I find the source documents on this? (I don`t have Technet right now.)