Guys,

Do we ever need to shrink the transaction log of a database following a simple recovery model?

I am assuming that the transaction log can potentially grow a lot.  For example, if...

Thanks James - you are correct - I actually learned it here:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=79030

Thanks guys.

Colin, I am a bit confused from your explanation.  Let's assume that I run the same job every 15 min from 2PM to 3PM (i.e. 5 times), but it...

Robert,

Your solution works great ... I am however having a bit of a problem following the code - could you clarify the significance of the number 30 used in the...

Sugesh: Thanks for the suggestion.  That definitely works.  However, it looks like the whole output goes into the 1st column of the excel spreadsheet, whereas I want each column of...

strange ... it worked for me fine.

Try the following: Add OPTION ROBUST PLAN as suggested somewhere here:

http://tutorials.aspfaq.com/8000xxxxx-errors/why-do-i-get-80040e14-errors.html

Greg,

Thanks for a great piece of code!

Running the following, I identified that my longest stored procedure spans 4 rows:

SELECT NAME, c FROM SYSOBJECTS S

INNER JOIN

(

select id, count(*) AS c from...

Hey John,

Thanks for the tip.  I am now 1 more step closer to finding an answer to the question, as I can now schedule the DTS package once it is...

Lowell,

Does your script solve the problem of stored procedure text spanning over multiple lines?

If so, could you please point to the part of the code that takes care of that.

Thank...

Rick,

Thanks for the script.

However, when I ran it, I got the following errors:

Warning: The table '#results' has been created but its maximum row size (8547) exceeds the maximum number of...

I would definitely go with the 2nd one:

- # logical reads is lower

- sub-tree cost is lower

These are 2 main metrics I currently use for measuring the efficiency of my...

Try sp_depends 'table name'.

This system sp queries sysdepends (system table).

Thanks guys.

After getting all the advice here and reading the article pointed out by Mohammed (http://support.microsoft.com/kb/195565), I decided to leave autostatistics with its default value of ON.

I am also...

From what I know (and my previous experience), the bookmarks should be avoided.

Also,

1. Look at the real execution plan

2. Look at the sub-tree cost

3. SET STATISTICS IO ON and then...

Guys,

Thanks for all the help.

I solved the problem by using what was stated in one of the postings above.  Namely,

Dataset.Tables[0].TableName = "Real Name"