>>Ok, glad it helped.
>
>It has started to do this again yesterday but on my account only. I have a lot of replies I guess.So, I forced a reindex. That did it. Now, today, it started to do it again. The log gives this:
>
>
>DECLARE @NoMember Integer
>
>SET @NoMember=1
>
>SELECT Thread.Numero,Thread.Title,Thread.Url,Thread.AddDate
> FROM (SELECT TOP 10 Reply.NoThread FROM Reply (NOLOCK)
> WHERE Reply.NoMember=@NoMember ORDER BY 1 DESC) Temp
> INNER JOIN Thread ON Temp.NoThread=Thread.Numero
>
>
>Duration: 5.7676 Count: 10
>
>Basically, the amount of time to process this query as increased a lot when I refresh the toolbar. I forced a reindex. It is ok again. But, there is something in there. I just can't find what is wrong with that index.
Try
SELECT Thread.Numero,Thread.Title,Thread.Url,Thread.AddDate
FROM Thread where EIXSTS (select 1 from (SELECT TOP 10 Reply.NoThread FROM Reply (NOLOCK)
WHERE Reply.NoMember=@NoMember ORDER BY 1 DESC) Temp where Temp.NoThread = Thread.Numero)
Slightly different variation of this same query.
I think you may need to ask this question in a different forum to get a better response. I suggest
http://social.msdn.microsoft.com/Forums/en-US/transactsql/threads - there are 20+ active SQL Server MVPs at this forum.
If it's not broken, fix it until it is.
My Blog