DB REORG

Is there a concept similar to DB reorganization in SQL
Server? The reason I am asking this is because batch
updates have doubled in it's turnaround time. Looking at
indexes, everything is fine. I thought that, perhaps,
data should be reorganized in appropriate pages and free
space.
If you have other suggestions, I would be interested in
them.
Thanks in advance
It depends of exactly what you mean with REORG. First, read in Books Online about below commands:
DBCC SHOWCONTIG
DBCC DBREINDEX
DBCC INDEXDEFRAG
Then (a must :-) ), read below great whitepaper on the subject:
http://www.microsoft.com/technet/pro.../ss2kidbp.mspx
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"RG" <anonymous@.discussions.microsoft.com> wrote in message
news:0caf01c4a580$58557910$a601280a@.phx.gbl...
> Is there a concept similar to DB reorganization in SQL
> Server? The reason I am asking this is because batch
> updates have doubled in it's turnaround time. Looking at
> indexes, everything is fine. I thought that, perhaps,
> data should be reorganized in appropriate pages and free
> space.
> If you have other suggestions, I would be interested in
> them.
> Thanks in advance
|||Thanks for your help.
You have mentioned index defragmation. What about data
table defragmation?

>--Original Message--
>It depends of exactly what you mean with REORG. First,
read in Books Online about below commands:
>DBCC SHOWCONTIG
>DBCC DBREINDEX
>DBCC INDEXDEFRAG
>Then (a must :-) ), read below great whitepaper on the
subject:
>http://www.microsoft.com/technet/pro.../sql/2000/main
tain/ss2kidbp.mspx
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"RG" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:0caf01c4a580$58557910$a601280a@.phx.gbl...
at
>
>.
>
|||This is why I asked what you mean by fragmentation and reorganization. Are you referring to re-claim
free space in your pages? Or making the data more contiguous?
Also, please consider that a table without a clustered index is a heap table. There is no order to
speak about here.
And for a table with a clustered index, the heap pages of the clustered index are your data pages.
I.e., to reorg such, you reorg the clustered index.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"RG" <anonymous@.discussions.microsoft.com> wrote in message
news:02aa01c4a592$7efe9bc0$a401280a@.phx.gbl...[vbcol=seagreen]
> Thanks for your help.
> You have mentioned index defragmation. What about data
> table defragmation?
>
> read in Books Online about below commands:
> subject:
> tain/ss2kidbp.mspx
> message
> at
|||All of the tables in question have clustered index. I am
looking to have the data stored contiguously because they
are pivotal tables in batch processing. In addition, I
would like to make sure I have my 10% free space per page
as batch is performing updates to these tables.
Thanks again
>--Original Message--
>This is why I asked what you mean by fragmentation and
reorganization. Are you referring to re-claim
>free space in your pages? Or making the data more
contiguous?
>Also, please consider that a table without a clustered
index is a heap table. There is no order to
>speak about here.
>And for a table with a clustered index, the heap pages of
the clustered index are your data pages.
>I.e., to reorg such, you reorg the clustered index.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"RG" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:02aa01c4a592$7efe9bc0$a401280a@.phx.gbl...
in[vbcol=seagreen]
free[vbcol=seagreen]
in
>
>.
>
|||That is just fine. All the information you need is in the sections in Books Online for the commands
I mentioned in my first post, and also make sure you read the KB article I posted an URL to in tat
same first post.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"RG" <anonymous@.discussions.microsoft.com> wrote in message
news:031d01c4a597$ec30ea90$a401280a@.phx.gbl...
> All of the tables in question have clustered index. I am
> looking to have the data stored contiguously because they
> are pivotal tables in batch processing. In addition, I
> would like to make sure I have my 10% free space per page
> as batch is performing updates to these tables.
> Thanks again