Microsoft SQL Server – create stored procedure ‚DefragmentIndexes‘ in master database

mswindows_logo.jpg   When a query is executed on a database, indexes are used to physically locate the data on disk. Due to frequent insert, update and delete statements this data can become fragmented. This is a serious performance issue. To mitigate this schedeule this script in a SQL Agent Job to frequently defragment you indexes. Create stored procedure DefragmentIndexes in master database. This stored procedure defragments the indexes in your database


Leave a Reply

You must be logged in to post a comment.