>Could it be parameter sniffing problem? Are you running an SP?
>
>
http://pratchev.blogspot.com/2007/08/parameter-sniffing.htmlThis 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?