Have you checked if/which indexes are being used? My thinking is the expression in the Where clause would make it non-sargable anyway.

Maybe you could post the query plan and...

Do you mean the system tables?

How is the task configured?

Does the Task Config. screen have a 'View TSQL' button? I can't remember if Sql 2005 has this. This should show you exactly what TSQL it...

Any number of things could cause this including missing indexes/statistics. You can probably eliminate most of the guesswork by posting the query plans from both queries and also the...

You may find TSQL's Output Clause helpful. You can check BOL for details.

http://msdn.microsoft.com/en-us/library/ms143729.aspx

How about a Full Text Index?

Keeping your skills current is simply not an option in these times, regardless of whether you are a freelancer or full time employee. Competition for work is fierce (at least...

I'm not quite sure I follow. Are you asking for an alternative to explicit error handling?

You can set SSMS to SqlCmd Mode and use code similar to the following:

-- Your Scripts Folder

:setvar scripts "d:\scripts\"

-- Execute your Script Files

use DatabaseA

:r $(scripts)ScriptFileToExecute.sql

:r $(scripts)ScriptFileToExecute.sql

use DatabaseB

:r $(scripts)ScriptFileToExecute.sql

:r $(scripts)ScriptFileToExecute.sql

It is interesting that you point out that the Procedure seemed to work fine before the performance suddenly degraded.

One of the things you want to do in such a situation...

I guess you could output the file as an xml file with the for xml statement tagged on the end of your query.

bcp "select * from adventureworks.humanresources.department

where departmentid =...

The actual process of storing / displaying the data you retrieve from the database is down to the frontend application language you use (C#, VB.Net etc.). You are unlikely...

It may also be a good idea to re-evaluate the need to return that number of rows to a webpage in one hit.

You are welcome!