I like Geoff's advice. Do not overwrite files. You'll overwrite the one that you need in a disaster situation.

Write a new file every time you do a full backup, and...

Stefan Krzywicki (1/13/2011)

---

They're trash money at this point. If people see money on the ground, they stop and pick it up. If they see a penny on the ground, they...

The author is an open source person, so I'm not surprised that Oracle/SQL Server aren't on there. I assume they qualify as RDBMSes, just like MySQL 😎

Too true, and too often I see developers that don't ever expect a query to fail...

You...

If you get that message, then somewhere in there you have a pattern that isn't being caught or isn't handled well. The Charindex doesn't find something and returns a 0.

First, I'd recommend you use this maintenance script. Lots of expert DBAs have reviewed it and they like it: http://sqlfool.com/2009/06/index-defrag-script-v30/

Second: This is not necessarily good advice.

after ur rebuild index/reorganize, you...

They should, and I've asked for this to be fixed. It's logged as a bug, but a low priority one. That page doesn't get many reads.

Ed has good suggestions for you.

I might also schedule a job that checks for new objects in the primary filegroup every night. Let it run and email you if there...

I would actually like to get new articles written, and then add a note in the article to link to the new one as a "better" way.

Don't forget that finding...

Took the kids to the mint this past summer. It was a near trip and we got to see pennies being minted. The tour said they've worked hard to reduce...

john.richter (1/12/2011)

---

I'm afraid this misses the point: 'Avoiding "the cloud" because it's "less secure" assumes that your local servers/computers are completely secure.'

...

This is the reason that vaults...

Robert Hermsen (1/12/2011)

---

we had a perfect experience the other day that should cause some concern for those wanting the cloud. Verizon lost a core router in our area and...

As my friend Jeff would say, Bwaa-haa-haa

I can't afford Benjamins. We're in a recession, so you have to make do with Jacksons.

If you want to work for a half hour, I am happy to email some...