Oh yes, I...

We use Litespeed. It does compressed backups and transaction log. There is also a ways to extract just one object from the Back up. Transaction log can be viewed easily...

I write it with leading commas and when my former colleague...

You will either need to have SQL Trace set up or you have to check Back up and compare. Or you should have a log table..:) If you have transaction...

When you say Update user table, are you talking about Data update or Table Alter?

As GSquared once pointed out, SQL 2005 has a default trace that keeps track of Table...

Did I open a can of worms? 😛

We might not be able to teach everyone or force them to learn. But maybe there are people who will learn by observation....

That might push away a newbie from coming to the site. Thats not what Steve would want. Maybe when an OP asks a question, we could educate them by providing...

Yea, I prefer the T-Shirt over the money.. 😀

Updating data in production in the middle of the night, that too probably with couple of beers inside and not enough caffeine, its a bad idea. You might do a...

Max (2/25/2009)

---

Here is a compilation of the 5 best standards I have come across:

1. Don't foist standards on others.

2. See above.

3. On Monday to Friday, see above.

4. Over the weekend,...

Hey Steve, Dont worry about it for now. I was actually kidding.

Maybe You could do one thing, Next time I write an article (If and when I write) please...

We could have a thread here that fights out the best practice list and we can provide a final list to the Newbies. 😀

Hear Hear Steve... I have a reason...Yay:D

Since this thread is the most popular here, I would like to ask everyone if we should have some standard while answering questions. For instance some of us, including...

So what kind of new idea should I come up with to get me a new T-Shirt...:D