Solved

how to reduce the size of the indexes in SQL Server

Posted on 2009-06-30
4
551 Views
Last Modified: 2012-05-07
I have a database of size 100gb.When I tried to see the disk usage the size of the index is more than data size.Pls see the attached screen shot.
Iam running out of disk space and Iwant to reduce that index size.
Pls help

Thanks
inde.GIF
0
Comment
Question by:shadyc
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 24749847
- you can drop some unused indexes
- do an index defragmentation
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 24749857
you must have created plenty of (eventually unusable) indexes.
you need to double-check each of the indexes if it is really used, and if not, drop it.

note: if the indexes graph includes the clustered indexes, those are actually containing the data of the table itself also...
0
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 500 total points
ID: 24749999
0
 

Author Comment

by:shadyc
ID: 24750070
Thanks for helping me...I'll look in to it and get back to you
0

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question