SQLServerCentral - Guest Columnist: James Rea

Transaction Log Growth, do you need it?

One of the most common questions asked about SQL Server has to do with the transaction log and why does it grow. James Rea brings us a good explanation here of what happens and what you should do about it. Read more...

By James Rea 2009/01/05 | Source: SQLServerCentral.com | Category: Transaction Log

Rating:

|

Discuss |

Briefcase | 14,853 reads

Finding and Listing ALL Procedures, Functions, and Views in SQL Server 2005

James Rea brings us another great article that shows you how to keep on top of the code that's stored in each of your databases. Read more...

By James Rea 2008/07/28 | Source: SQLServerCentral.com | Category: T-SQL

Rating:

|

Discuss |

Briefcase | 11,998 reads

Introduction to the Transaction Log

The transaction log is a fairly complex construct in SQL Server and present in every database installation. New author James Rea brings us a great introduction to how the log works and how to maintain it. Read more...

By James Rea 2009/11/06 (first published: 2008/07/02) | Source: SQLServerCentral.com | Category: Design and Theory

Rating:

|

Discuss |

Briefcase | 23,517 reads