select statement run very slow after installing sp3

From: new (anonymous_at_discussions.microsoft.com)
Date: 07/02/04 

Date: Fri, 2 Jul 2004 05:46:20 -0700

Select statement is running 3 time slower than before
after I installed sp3 in SQL 2000.(before is sp1).
Do anyone know why and how to fix it?
Thanks all reply.

Relevant Pages

  • Re: How to keep SQL2000 in upgrade to R2
    ... If he needs sql 2000 he has to stay on SP1 without R2. ... The r2 downgrade right is an entire "suite" downgrade right. ... Just don't remove your Sharepoint instance, and only install R2 Technology on your SBS SP1 Server. ... The public newsgroup only focuses on SBS related technical issues, for other Microsoft products, we recommend you to post to appropriate newsgroup to get most qualified responses. ...
    (microsoft.public.windows.server.sbs)
  • Re: Windows XP SP1 BUG?
    ... theso insert the cd & do a upgrade will fix this? ... what about un installing ... sp1 will that work i will try it tells me a few programs may not run if i do ... up on the recovery console and went through the "upgrade install". ...
    (microsoft.public.windowsxp.security_admin)
  • RE: SQL Server 05 offered thru Update services fails to install
    ... I am having the same issue of SQL 2005 sp1 not ... updates proceeded to obtain SQL Server 2005 SP1. ... [ClientId = MicrosoftUpdate] ...
    (microsoft.public.windowsupdate)
  • Re: .oft templates / signature problem
    ... I didn't say it would fix the problem. ... I said OL2003 SP1 has the same ... behavior and registry value as OL2002 SP3+hotfix. ...
    (microsoft.public.outlook.general)
  • Re: SQL Adapter stops polling
    ... Are you running on Windows 2003 SP1 by any chance? ... On a system with 4 SQL Receive locations I have begun to notice the same ... We are in the process of testing a hot fix from Microsoft to correct the ... SQL Adapter itself, or other adapters are behaving badly by not ...
    (microsoft.public.biztalk.general)