Nicely said. 

So long as you don't use select * on your table you should be ok - the text data itself is actually stored separately and a pointer to it is...

You are not alone

I suppose if your data is nicely cleaved into small time chunks of 1-1.5GB each, then you shouldn't have too...

Well done sushila

Hopefully last past on this - I'm not gonna bother quoting and rebutting other people's statements like I feel I am...

Get a life everyone - even if you didn't find the article amusing (I did - my choice), get over it.  It's obvious that many of you have signed up...

Hmmm - yeah amazing what a response this has generated.

The article was damn funny and was the perfect thing for me to read at the end of a long busy...

In that case, there was an article posted in the last week or so that gave many ideas (as well as its following discussion where even more ideas were presented)...

Glad to help - look forward to having u as a continuing member

Also, log on to the server at 5:40 and run sp_lock, sp_who and sp_who2 and post the results here...

There is a job that reindexes the tables periodically, which I thought was the culprit, but the job is not disabled and the DB is still ballooning.

You mean the job is still...

Just to be clear, you have FULL, DIFFERENTIAL and INCREMENTAL backups.

Full backups are what they sould like.

Differential are what you referred to as incremental backups.

Then you have incremental backups which...

You may well find a script is running somewhere doing a complex reindex using DMO on your database - this reindex would hold locks on your tables and effectively your...

Hi.  Yeah, it is "streaming" - you can store anything you like up to 2GB in a single record.  It could be any binary data at all, needn't be a...

Yes a backup and restore is probably the easiest way to duplicate an online database.  Is this backup & restore occurring on the same server or are you backing up from...

What exactly do you want to "read" from the log - do you want to know what people have changed (like an audit trail?)