Thank you for the compliment.

It absolutely is wonderful to see the row count for each table, the purpose behind the final (total) count is very useful in cases of replication...

Steve, and everyone else...

Thanks for the great compliments!

Yes, as mentioned in my article, there is no performance benefit to multiple log files. It seems the only benefit is file management...

LimeyTone,

Those SPs you listed in regards to not having the "Is_MS_Shipped" flag should, in fact, NOT have the flag. They should not be marked as being shipped from Microsoft because...

arup_kc,

Essentially there is no difference between the two views except for when they were created; however, sysobjects is a SQL 2000 view and was left in SQL 2005 for backward...

Abhijit,

The problem with using sys.procedures is it ONLY lists out the user created Stored Procedures; this article was in regards to finding ALL procedures (including the MS provided SPs and...

Actually, the sentence is correct but can easily be mis-read.

The second part of the sentence is saying that you should not use anything you have not thoroughly tested in a...

Thank you for the nice remarks.

As pointed out in previous posts; the correct location to create stored procedures that are distributed to new databases is to use the 'model' database....

Thank you to everyone for the great comments on additional methods to obtain the same data; and especially to those that have methods that could improve on the speed of...

John,

Have you considered using the Bulk-Logged Recovery Model?

BOL has a good section called "Prerequisites for Minimal Logging in Bulk Import" (http://msdn.microsoft.com/en-us/library/ms190422.aspx)

Maybe, this will help ease your burden with the...

To illustrate further on what Charles is saying, think in the terms of a large organization that has many, many transactions per day. Imagine that your servers are at peak...

Thank you for pointing out the write-ahead specification (to both Charles and Stephanie). This is actually a standard that is followed to ensure that any changes to data are ACID...

Hi,

This is a quick update to a major typo in the article.

In the section titled "Shrinking the Log"; I typed in that the command FILESHRINK is used to shrink...

Bill,

Thank you for the great detailed history there! 🙂

Thanks,

James Rea

Charles,

Thank you for the kind comments. This article originally started based on there being so many people asking why the transaction log suddenly ballooned in size over night, then the...

This further illuatrates my point. An exceptional DBA that can answer 'why' must be able to research the subject. They must know what the right question is to ask, and...