about indexes

Hi Grus,
How can i know that on what date a index was created and how many times
it was reindexed.
Or how offen it being reindexed.
from
DollerSQL Server doesn't keep such information. So you would have to keep track of
it yourself, possibly
using a Profiler trace.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"doller" <sufianarif@.gmail.com> wrote in message
news:1132808347.911840.163270@.g44g2000cwa.googlegroups.com...
> Hi Grus,
> How can i know that on what date a index was created and how many times
> it was reindexed.
> Or how offen it being reindexed.
> from
> Doller
>

about indexes

Hi Grus,
How can i know that on what date a index was created and how many times
it was reindexed.
Or how offen it being reindexed.
from
Doller
SQL Server doesn't keep such information. So you would have to keep track of it yourself, possibly
using a Profiler trace.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"doller" <sufianarif@.gmail.com> wrote in message
news:1132808347.911840.163270@.g44g2000cwa.googlegr oups.com...
> Hi Grus,
> How can i know that on what date a index was created and how many times
> it was reindexed.
> Or how offen it being reindexed.
> from
> Doller
>

about indexes

Hi Grus,
How can i know that on what date a index was created and how many times
it was reindexed.
Or how offen it being reindexed.
from
DollerSQL Server doesn't keep such information. So you would have to keep track of it yourself, possibly
using a Profiler trace.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"doller" <sufianarif@.gmail.com> wrote in message
news:1132808347.911840.163270@.g44g2000cwa.googlegroups.com...
> Hi Grus,
> How can i know that on what date a index was created and how many times
> it was reindexed.
> Or how offen it being reindexed.
> from
> Doller
>