Sunday, March 11, 2012

defrag database

Hello all
Is there an easy way to see if my db needs to be defraged?
ThanksWhat version of SQL Server?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Andre Gibson" <AndreGibson@.discussions.microsoft.com> wrote in message
news:80E6AA03-C748-4A6E-96EB-D2D7A7E48AB1@.microsoft.com...
> Hello all
> Is there an easy way to see if my db needs to be defraged?
> Thanks|||sorry Sql Server 2000
"Tibor Karaszi" wrote:
> What version of SQL Server?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Andre Gibson" <AndreGibson@.discussions.microsoft.com> wrote in message
> news:80E6AA03-C748-4A6E-96EB-D2D7A7E48AB1@.microsoft.com...
> > Hello all
> >
> > Is there an easy way to see if my db needs to be defraged?
> >
> > Thanks
>|||Check out DBCC SHOWCONTIG
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Andre Gibson" <AndreGibson@.discussions.microsoft.com> wrote in message
news:DE1AD78C-62F8-4E03-ACBF-05A264D26B33@.microsoft.com...
> sorry Sql Server 2000
> "Tibor Karaszi" wrote:
>> What version of SQL Server?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Andre Gibson" <AndreGibson@.discussions.microsoft.com> wrote in message
>> news:80E6AA03-C748-4A6E-96EB-D2D7A7E48AB1@.microsoft.com...
>> > Hello all
>> >
>> > Is there an easy way to see if my db needs to be defraged?
>> >
>> > Thanks
>>

No comments:

Post a Comment