Updated ReIndexAll.sql script

[tomasont]

The ReIndexAll.sql script uses the DBCC DBREINDEX command, which was deprecated over ten years ago.  Does anyone have a version of the script that uses ALTER INDEX instead?  

[ChrisG]

I haven't seen anybody write a version of the script using ALTER INDEX. If you do one, it would be great to share it here!

FWIW, DBCC DBREINDEX is still fully supported by all current versions of SQL Server. The page at https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-dbreindex-transact-sql?view=sql-server-ver16 indicates this feature will be removed in a future SQL Server release. So if that does happen then the ReIndexAll.sql script would need to be updated when support for that SQL Server release is added to FlexNet Manager Suite.

[alexander_frit]

We are using a slightly adjusted version of example D from following documentation:

sys.dm_db_index_physical_stats (Transact-SQL) - SQL Server | Microsoft Docs