This week only. Pastebin PRO Accounts Christmas Special! Don't miss out!Want more features on Pastebin? Sign Up, it's FREE!
Guest

Big difference in execution time of stored proc between Managment Studio and TableAdapter

By: a guest on Feb 26th, 2012  |  syntax: None  |  size: 0.16 KB  |  views: 20  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. EXEC    [dbo].[uspMovesReportByRouteStep]
  2.         @RouteStep = 12000,
  3.         @RangeBegin = N'12/28/08',
  4.         @RangeEnd = N'1/18/9'
  5.        
  6. exec sp_msforeachtable "dbcc dbreindex ('?')"
clone this paste RAW Paste Data