SET SARCASM_MODE ON

What do you call 500 lawyers at the bootom of the sea ?

SET SARCASM_MODE OFF

I just forwarded the article to the CIO ... he needed something to start...

I tend to agree with Gail. Here's a couple of modification and potential 'gotchas'. We have to start out with the "gotchas" first because they may alter your choice of...

You may also want to lok at 'striping' your backup target files. I have a 300 Gb database in simple recovery mode being backed up to 4 files. The execution...

What is the 'recovery mode' of the database ?

If it is 'simple' recovery more, then transaction log backups to a file are not possible.

If it is any other recovery mode...

In course of life, the intangibles, by far, outweigh the tangibles in life.

Have a great weekend Steve !

Tis a spirited and quite humorous discussion today John ... Unfortunately I do not know how to translate your request about "Caesar" and his "equine" riding skills. Sorry to disappoint...

I dunno ... color me a half a bubble off ...

It has nothing to do with trust - this is something you earn. It's actually professionalism - something you practice at work or in your...

A paper trail is needed <period>

I would even opt to go one step further since there will probably never be 'standardized' electronic voting machines. Let's just go back to plain...

Let's get real ... money, flextime, training, bonuses only go so far. The phrase "Know thyself" is of paramount importance and usually the one most often looked over or forgotten.

Quite...

What is the salary range and bonus target ?

SET REALITY_MODE ON

I'm sorry ... after reading all of the responses - (I have done quite a few live demos myself), "memorex" has no place. "live" is the only way...

Clarification - minimally logged as in a truncate table, page deallocations are logged as opposed to individual rows being logged when using delete.

For databases in simple recovery mode use:

BACKUP LOG database_name WITH  TRUNCATE_ONLY

Well Lowell, if you can get your stuff to run efficiently on the present 'development' equpment you have. By Jove, when it goes into production on the 'good' stuff' it...

One additional thought is to partition the tables based on the month. This will allow you quick and easy maintenance when archiving and purging data. The additional benefit is that...