Rebuild all the indexes ?

Can anyone let me know like we need to rebuild all the indexes of all tables
every day? or the specific indexes?
Thanks
But be careful, its an undocumented feature:
EXEC sp_MSforeachtable @.command1="print '?' DBCC DBREINDEX ('?')"
DBCC DBREINDEX
( 'database.owner.table_name'
[ , index_name
[ , fillfactor ]
]
) [ WITH NO_INFOMSGS ]
Arguments
For a specifix table --> BOL
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Joh" <joh@.mailcity.com> schrieb im Newsbeitrag
news:%23hb$TBRRFHA.3672@.TK2MSFTNGP10.phx.gbl...
> Can anyone let me know like we need to rebuild all the indexes of all
> tables
> every day? or the specific indexes?
> Thanks
>
|||my question is that we need to reubuild daily basis or not?
"Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:#e1q6FRRFHA.3156@.TK2MSFTNGP15.phx.gbl...
> But be careful, its an undocumented feature:
> EXEC sp_MSforeachtable @.command1="print '?' DBCC DBREINDEX ('?')"
>
> DBCC DBREINDEX
> ( 'database.owner.table_name'
> [ , index_name
> [ , fillfactor ]
> ]
> ) [ WITH NO_INFOMSGS ]
> Arguments
> For a specifix table --> BOL
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "Joh" <joh@.mailcity.com> schrieb im Newsbeitrag
> news:%23hb$TBRRFHA.3672@.TK2MSFTNGP10.phx.gbl...
>
|||Please see this whitepaper
http://www.microsoft.com/technet/pro.../ss2kidbp.mspx
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
"Joh" <joh@.mailcity.com> wrote in message
news:uCjtKIRRFHA.1528@.TK2MSFTNGP09.phx.gbl...
> my question is that we need to reubuild daily basis or not?
> "Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote
> in
> message news:#e1q6FRRFHA.3156@.TK2MSFTNGP15.phx.gbl...
>