Re: 50% processor Utilisation - Please help I am desperate

From: "David Portas" <REMOVE_BEFORE_REPLYING_dportas@xxxxxxx>
Date: 27 Sep 2005 03:28:49 -0700

Cursors are typically single threaded operations and are usually
s-l-o-w. Replace the cursor would be my first suggestion.

--
David Portas
SQL Server MVP
--

.

Prev by Date: Re: 50% processor Utilisation - Please help I am desperate
Next by Date: Log shipping
Previous by thread: Re: 50% processor Utilisation - Please help I am desperate
Next by thread: How to give User the option to cancel a script
Index(es):
- Date
- Thread

Relevant Pages

Re: Query question?
... Better specs would help us with future questions. ... David Portas ... SQL Server MVP ... Prev by Date: ...
(microsoft.public.sqlserver)
Re: SQL 2000, SP3a "TOP 100%"
... The best place to use ORDER BY is when you query the view. ... David Portas ... SQL Server MVP ... Prev by Date: ...
(microsoft.public.sqlserver)
Re: Price of SQL Server
... Workgroup Edition ... David Portas ... SQL Server MVP ... Prev by Date: ...
(microsoft.public.sqlserver.setup)
Re: datafile and log file on cluster
... files on separate physical disks. ... David Portas ... SQL Server MVP ... Prev by Date: ...
(microsoft.public.sqlserver.setup)
Re: How to connect to a dedicated m/c
... Windows 2003. ... David Portas ... SQL Server MVP ... Prev by Date: ...
(microsoft.public.sqlserver.connect)