SQL Server Performance

Search Results

Search Again
  1. mtzoanos

    Same statement executes 10 times faster as raw sql in Query Analyzer then in a Stored Proc

    Post by: mtzoanos, Aug 15, 2007 in forum: T-SQL Performance Tuning for Developers
    Dinakar, Again, thank you very much for your help. I tried the NOEXPAND but it failed and I was able to figureout why. Before the Create Proc...
  2. mtzoanos

    Same statement executes 10 times faster as raw sql in Query Analyzer then in a Stored Proc

    Post by: mtzoanos, Aug 15, 2007 in forum: T-SQL Performance Tuning for Developers
    Thank you very much for the reply. You're right. Using "with recompile" adds overhead and I used it to generate the proc and when executing it to...
  3. mtzoanos

    Same statement executes 10 times faster as raw sql in Query Analyzer then in a Stored Proc

    Thread by: mtzoanos, Aug 15, 2007, 5 replies, in forum: T-SQL Performance Tuning for Developers
    Hi, I apologize for the long post but I am trying to give as much information as I can about the steps I've taken to troubleshoot this. We have a...
Showing results 1 to 3 of 3
Search Again