stored procedure keeps spinning

• riya_dave

  Hall of Fame

  Points: 3106

  More actions

  July 11, 2013 at 8:28 am

  #277264

  hi

  when i run sp in 1 server it keeps spinning and on other server i am getting result

  what could be the reason

  i tried with recompile but no luck

  thanks

• Sean Lange

  SSC Guru

  Points: 286590

  More actions

  July 11, 2013 at 8:29 am

  #1631609

  riya_dave (7/11/2013)

  ---

  hi

  when i run sp in 1 server it keeps spinning and on other server i am getting result

  what could be the reason

  i tried with recompile but no luck

  thanks

  It could be nearly anything. Can you post some actual details? Table structures, the code, actual execution plan.

  _______________________________________________________________

  Need help? Help us help you.

  Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

  Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

  Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
  Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
  Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
  Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

• Alan Burstein

  SSC Guru

  Points: 61141

  More actions

  July 11, 2013 at 12:20 pm

  #1631705

  I would start here: http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]

  "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

  -- Itzik Ben-Gan 2001