June 2007 - Posts

Increase Stored Procedure execution performance dramatically
18 June 07 05:52 AM | idragoev | 0 Comments   

Last month we spent a lot of time in data loading optimization due to performance problems. I started with optimization of the heaviest views and put them in parameterized stored procedures . I also used a simple method to check the performance by measuring Read More...

Filed under: execution plan, optimization, Stored Procedure, Performance, Stored Procedure execution, sql optimization, sql stored procedure optimization, database design