The sum of all SQL Server matter that exist,
and the space in which all SQL Server events
occur or could occur.
Welcome to SQL Server Universe.com Sign in | Join | Help
in
Home SS SLUG Forums Articles Photos Downloads

Browse by Tags

All Tags » Rebuilding Indexes   (RSS)
  • Re: Index creation taking long time

    Hi, 1.2 million records is quite a considerable amount of records when the number of indexes are high such as 21 in your case. Try not creating indexes for fields which are not used frequently in queries (such as in JOINs or WHERE conditions), or on fields which are of a large size. This would only take up more space on your hard disk and more ...
    Posted to T-SQL (Forum) by gogula on May 7, 2008
Powered by Community Server, by Telligent Systems