>Could it be parameter sniffing problem? Are you running an SP?
>
>http://pratchev.blogspot.com/2007/08/parameter-sniffing.html

This is how the command is done:

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 

My version is:

Microsoft SQL Server Management Studio   10.0.1600.22 ((SQL_PreRelease).080709-1414 )
Microsoft Analysis Services Client Tools 2007.0100.1600.022 ((SQL_PreRelease).080709-1414 )
Microsoft Data Access Components (MDAC)  2000.086.3959.00 (srv03_sp2_rtm.070216-1710)
Microsoft MSXML                          2.6 3.0 4.0 6.0 
Microsoft Internet Explorer              8.0.6001.18702
Microsoft .NET Framework                 2.0.50727.3603
Operating System                         5.2.3790

Is there something newer?