Post reply

Automatically killing long running queries?

  • August 17, 2005 at 5:30 pm

    #582897

    Set the limit of "Search" results to 1000 or whatever you want.

  • August 18, 2005 at 9:34 am

    #583131

    Yes, put a TOP clause in the query to limit the number of rows.

    Also, we use Idera SQL Diagnostic Manager, and like it a lot. It's great for monitoring, and getting a jump on that "surprise" issue that pops up now and then.

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply