Stored Procedure "ssi_indexrebuild": - Added hardcoded LOCKTIMEOUT of 10 seconds; line 277 - Improved TRY CATCH part; lines 276 - 292
Added hardcoded LOCKTIMEOUT of 10 seconds; line 277 Improved TRY CATCH part; lines 276 - 292
<<It's not important HOW you maintain it, it's important THAT you maintain it!>> (Jörg Stryk) Yaaawwwnnn ... Yet another set of Database Maintenance routines for SQL Server ... really? Yes, indeed! Just adding my flavor of this matter, so you've got more to choose from! The M3 procedures should help the EXPERIENCED Database Administrator to quickly implement sufficient maintenance. Basically these Procedures just perform the essential Maintenance as Integrity Checks, Index Rebuilds and Statistic...
<<It's not HOW you maintain it, it's important THAT you maintain it!>> (Jörg Stryk) Yaaawwwnnn ... Yet another set of Database Maintenance routines for SQL Server ... really? Yes, indeed! Just adding my flavor of this matter, so you've got more to choose from! The M3 procedures should help the EXPERIENCED Database Administrator to quickly implement sufficient maintenance. Basically these Procedures just perform the essential Maintenance as Integrity Checks, Index Rebuilds and Statistic Updates, all...