Execution Plan

• drew.georgopulos

  SSCarpal Tunnel

  Points: 4931

  More actions

  May 15, 2013 at 9:18 am

  #275246

  when i'm looking at stored procedures i add the following to the top of the code

  dbcc freeproccache

  set statistics io on

  set statistics time on

  Is there also a way to turn on the real execution plan this way, by a command, instead of by mouse?

  thanks very much

  drew

• Neeraj Dwivedi

  SSCertifiable

  Points: 6768

  More actions

  May 15, 2013 at 9:21 am

  #1615490

  CTRL+M

• drew.georgopulos

  SSCarpal Tunnel

  Points: 4931

  More actions

  May 15, 2013 at 9:50 am

  #1615506

  obviously, didnt know that:cool:

  thanks a ton!

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  May 15, 2013 at 10:20 am

  #1615523

  SET STATISTICS XML ON;

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question

• drew.georgopulos

  SSCarpal Tunnel

  Points: 4931

  More actions

  May 16, 2013 at 7:13 am

  #1615766

  Hot Dawg!

  even better

  thanks very much

  drew