Re: optimisation with extreme sql

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Uri Dimant (urid_at_iscar.co.il)
Date: 03/15/04 

Date: Mon, 15 Mar 2004 12:57:52 +0200

Jeho
Your first step for optimization your query will be re-writing the stored
procedure to remove cursors.

I am pretty sure it is a key of your stored procedure's perfomance.

"Jeho" <j.lezy@b2l.com> wrote in message
news:71addc2b.0403150251.47fd62ab@posting.google.com...
> Hello,
>
> I want to optimise my stored procedures (using several cursors...) in
> sql server 2000. They are called by DTS and it takes too much time
> (around 30 minutes) to execute them, because of the large amount of
> data.
>
> I've heard about using extreme sql to optimise the procedures, but i
> know nothing about it.
>
> Can anyone explain me what we can do with extreme sql ? how it works ?
> do i need to install a special component ? ....
> does anyone have interesting web sites adresses ?
>
> Thank you for helping
>
> Jeho

Relevant Pages

  • Re: DB Backup problem
    ... I support the Professional Association for SQL Server ... Ditch the Maintenance Plan Optimizations. ... it is the optimization step that is likely ... > 6:00pm - Transaction Log Backup ...
    (microsoft.public.sqlserver.server)
  • Re: Transfer an SQL database?
    ... Queries and SQL Servers. ... There are a lot of factors to consider when looking at optimization, ... assuming it is similar to your C# + SQL Server configuration (i.e., ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: VFP and SQL
    ... sounds like the database is not optimized for retrieval. ... 500 megabytes on a data store is nothing for VFP, but optimization is ... I was on a huge site with sql server 7, ... Mondo Cool TeleCom -> http://www.efgroup.net/efgcog.html ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Denormalization
    ... It's a technique common to DBMSs that don't have better optimization ... Most enterprise DBMSs do allow physical partitioning without ... State what version of SQL Server you are using and specify the content ...
    (comp.databases)
  • Re: Stored procedure failed: maximum open cursors exceeded
    ... PL/SQL has the optimization where cursors are not closed. ... this function from a jdbc app and not properly closing cursors. ...
    (comp.databases.oracle.server)