SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Automatically Create indexes as needed

By Steven Christensen,

This script is designed as a job in sql server agent to automatically optimize indexes in your database. Simply run the job and it will create the necessary indexes to optimize performance.
  Replace [user name here] with your user name and replace [database name] with your database.  Then when you need indexes added to optimize performance you just run this job in the database that you are optimizing.

Total article views: 683 | Views in the last 30 days: 9
Related Articles

Database index design and optimization: Some guidelines

Well-designed indexes are an important part of database optimization because they are the key factor...



how Optimizer selects the index?


Database Optimization Task Disconnect

Database connection lost during optimization task.


How to optimize Inventory database transaction

How to optimize Inventory database transaction


Indexes optimize for the system databases

Maintenance of the system databases in SQL Server regarding the indexes is important too. The system...