Viewing 3 posts - 1 through 3 (of 3 total)
yep, If I remove index and keep order by I have no problems with my sp (it executes in 0sec).
If I dont remove index and remove order by -...
July 5, 2011 at 7:58 am
#1348291
see attachment
July 5, 2011 at 5:07 am
#1348179
Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86) Jul 9 2008 14:43:34 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition on Windows NT 5.2 <X86> (Build 3790: Service Pack 2)...
July 4, 2011 at 2:19 pm
#1348006