fragmented (dbcc showcontig X). I want to defrag the table
but when i do dbcc dbreindex it doesnt do anything. Stays
the same way. I am experiencing the same problem on
various tables. Can anyone help me please?Although your table probably should have a clustered and some non-clustered
indexes, ( that is another conversation.)
You might simply create a clustered index on the table, then drop it... The
table rows will be cleaned up during the create index.
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"
" <anonymous@.discussions.microsoft.com> wrote in messagenews:050901c3de70$8682d350$a301280a@.phx.gbl...
quote:
> I have a table "X" and it has no indexes. However it is
> fragmented (dbcc showcontig X). I want to defrag the table
> but when i do dbcc dbreindex it doesnt do anything. Stays
> the same way. I am experiencing the same problem on
> various tables. Can anyone help me please?
No comments:
Post a Comment