First of all, there is an sp_helptext command. What you could do is to dump the contents of this to a text file for each of the stored procedures.

You could...

My first bit of advise is to put as much of the query in SQL server as possible to limit the amount of code that you have to write in...

I had a discussion with some folks who were needing this as well. I believe to solve their problem, they ran the output through another program to look for the...

I agree that formatting is the job of the presentation layer, but aggregating data may not be. While the original question did not say, the data may be used in...

Indexes and statistics are definitely worth checking. However, I would also consider rewriting the code for the text file processing into a stored procedure as well. Even if you keep...

I think that one option is to make use of temp tables, and if you reuse the result, persist the data in a global temp table rather than a local...

I think that one option is to make use of temp tables, and if you reuse the result, persist the data in a global temp table rather than a local...

Look for Lock problems.

Check statistics, update as necessary.

Reindex.

Use SPs over ad hoc T-SQL.

Limit joins - opt for temp tables where large, relatively static intermediate results are reused.

Break the problem down...

try doing datediff for number of days instead.

Beer is the answer to all the world's woes.

I like Lumigent's log reader. but allow me to warn you, I believe it may interfere with standby server functionality because of its interaction with the logfile