Posted by John Bell on 03/12/07 08:44

On Mar 12, 8:23 am, "John Bell" <jbellnewspo...@hotmail.com> wrote:
> Hi Rob
>
> If there is no entry the index has not
> been used since the last reboot, so you would need to see if it will
> ever be usfull.
>
Just to correct myself! That is not quite right, look for entries with
values of 0
see https://www.microsoft.com/technet/technetmag/issues/2007/03/SQLIndex/default.aspx
for more.

John

• Next in forum: Re: get value of last item in column?
• Prev in forum: Re: SQL to combine columns
• Thread view: Re: index fragmentation LogicalFragmentation -how bad is bad - silly question alter

[Reply to this message]