rebuild index

Question

rebuild index

naresh.talla

SSCommitted

Points: 1929
More actions
November 22, 2011 at 11:14 pm

#390930

Hi all,
i am using sql server 2005
one of my table fragamented around 80 percent.
i have done rebuild index on table.after rebuild fragamented percentage is same 80.
i have rebuild index done through gui and command through i.e alter index.
can someone help on this............

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Let me guess, tiny table, index about 5 pages in size?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

paul.scoging Grasshopper Points: 20 More actions · Answer 2

Found a handy defrag script on sqlserverpedia.com that might be of interest to you ;-):

http://sqlserverpedia.com/wiki/Index_Maintenance

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 3

paul.scoging (11/24/2011)

Found a handy defrag script on sqlserverpedia.com that might be of interest to you ;-):

http://sqlserverpedia.com/wiki/Index_Maintenance%5B/quote%5D

Actually here's the original's author's website and latest version of that script => http://sqlfool.com/2011/06/index-defrag-script-v4-1/

paul.scoging Grasshopper Points: 20 More actions · Answer 4

paul.scoging

Grasshopper

Points: 20

November 24, 2011 at 5:07 am

#1412648

Cool, that's one for the favorites.

ChrisTaylor SSCarpal Tunnel Points: 4527 More actions · Answer 5

GilaMonster (11/23/2011)
Let me guess, tiny table, index about 5 pages in size?

I'm +1 for this!

_________________________________________________________________________________SQLGeordieWeb:- Jarrin ConsultancyBlog:- www.chrisjarrintaylor.co.ukTwitter:- @SQLGeordie